How do I add a Line break in a SQL Server Stored Procedure?

Question

I'm making a Stored Procedure that basically concatenates a long string with data from many records.

I want to do:

set @output = @output + 'aaa' + LINEBREAK

How do I specify that line break?

Solution 1

DECLARE @LINEBREAK AS varchar(2)
SET @LINEBREAK = CHAR(13) + CHAR(10)

Solution 2

Try this:

set @output = @output + 'aaa' + char(13)