You can use the CHAR(10),CHAR(13) values in order to go to a new line. Play around with them in PRINT statements to get a feel for them.

Jeff

Bhanu Poojari <mssqldba-ezmlmshield-x91175947.[Email address protected] wrote:
Hi,

I need to send out a formatted text message in SQL e-mail.

i.e
'Hi,
How are you?
Warm Regards,
ABCD'

instead of

'Hi,How are you? Warm Regards,ABCD'

What is new line equivalent to be used in the stored procedure?

Thanks,
B


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page