<div>
Here we go.<br />

<pre><code id="code-491587">DECLARE @TEXT AS VARCHAR(100)
SELECT @TEXT = 'THIS IS COOL'+CHAR(10)+'BUT THIS IS EVEN COOLER'
PRINT @TEXT

SELECT @TEXT = 'THIS IS COOL'+CHAR(13)+'BUT THIS IS EVEN COOLER'
PRINT @TEXT
</code></pre>
</div>


Here we go.


DECLARE @TEXT AS VARCHAR(100)
SELECT @TEXT = 'THIS IS COOL'+CHAR(10)+'BUT THIS IS EVEN COOLER'
PRINT @TEXT

SELECT @TEXT = 'THIS IS COOL'+CHAR(13)+'BUT THIS IS EVEN COOLER'
PRINT @TEXT


<div>
Thanks, that worked perfectly. &nbsp;I was missing the fact that i needed to declare and set the variable above rather than directly in the EXEC statement.
</div>


Thanks, that worked perfectly.  I was missing the fact that i needed to declare and set the variable above rather than directly in the EXEC statement.

<div>
<div class="content wysiwyg-content">
I am using sp_send_dbmail and it is working fine. &nbsp;I want to add some additional text into the @body parameter. &nbsp;Is there a way to a insert a couple of blank lines to separate this new text? &nbsp; Maybe a control code or something.<br />
<br />
I know I can set the body_format parameter to HTML and insert &lt;br&gt; statements, but i would like to avoid that if possible.<br />
<br />
Thanks.
</div>
</div>


I am using sp_send_dbmail and it is working fine.  I want to add some additional text into the @body parameter.  Is there a way to a insert a couple of blank lines to separate this new text?   Maybe a control code or something.

I know I can set the body_format parameter to HTML and insert <br> statements, but i would like to avoid that if possible.

Thanks.

sp_send_dbmail - need new lines in body

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.