Login     Register

        Contact Us     Search

XLeratorDB/strings Online Documentation

SQL Server CRLF function


CRLF

Updated: 30 April 2009

Use CRLF to insert a carriage return (Char(13)) line feed (Char(10)) into a string
Syntax
SELECT [wctString].[wct].[CRLF] ()
Arguments
There are no arguments for this function
 
Return Types
nvarchar(4000)
Remarks
·         Use CRLF instead of Char(13) + Char(10)
Examples

select
'now is the time ' + wct.CRLF() + 'for all good men ' + wct.CRLF() + 'to come to the aid '
+ wct.CRLF() + 'of their country'
 

This produces the following result
---------------------------------------------------------------------------
now is the time
for all good men
to come to the aid
of their country
 
(1 row(s) affected)

 



Copyright 2008-2013 WestClinTech LLC         Privacy Policy        Terms of Service