CRLF

Updated 2023-11-10 14:33:59.883000

Syntax

SELECT [westclintech].[wct].[CRLF] ()

Description

Use the scalar function CRLF to insert a Carriage Return Char(13) and a Line Feed Char(10) into a string.

Return Type

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.

{"columns":[{"field":"column 1"}],"rows":[{"column 1":"now is the time"},{"column 1":"for all good men"},{"column 1":"to come to the aid"},{"column 1":"of their country"}]}