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

<p>I want to do:</p>

<pre><code>set @output = @output + 'aaa' + LINEBREAK
</code></pre>

<p>How do I specify that line break?</p>

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