I'm defining a varchar variable in a stored procedure and it would be easier to read if I could insert carriage returns into the variable.
Here's the variable
SET @BODY1 = @SEVERITY + @SUBJ + @FNAME + ' ' + @LNAME +
' ' + @COMPANY + ' ' + @PHONE + ' ' + @EMAIL + @FB_DESC
@BODY1 is the @message parameter for xp_SENDMAIL so I don't know if there is another option for me.