XLeratorDB/strings Online Documentation
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)