ryan.price (11/23/2008)
RE: CR/LF/NewLine (Cade Roux)Actually, with Transact-SQL, it's even easier, just embed the newline in your string.
Yeah, I use that occasionally. I would prefer if there was a \r escape sequence or something, though. (I usually DECLARE @CRLF and SET @CRLF = CHAR(13) + CHAR(10) when I need that)