====== Line termination literals ======

Windows-based systems use the two-character combination "carriage return, new line" at the end of a line of text. To produce this literal for inclusion in strings (for example as a [[tsql:string_concatentation_as_an_aggregate_operator|string concatenation separator]]), use ''CHAR(13) + CHAR(10)''. For example:
<code tsql>SELECT 'FirstLine' + CHAR(13) + CHAR(10) + 'SecondLine'</code>

{{tag> tsql development}}