You just concatenate the string and insert a CHAR(13) where you want your line break. Example: DECLARE @text NVARCHAR(100) SET @text = 'This is line 1.' + CHAR(13) + 'This is line 2.' SELECT @text This prints out the following: This is line 1. This is line 2.
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)