Here is a clean and efficient way to embed carriage returns into a string. I prefer this way instead of concatenating the entire CHAR(13)+CHAR(10) to the end of every string. This replace function also comes in handy in most instances where you need to append strings. declare @Note varchar (200) SET @Note = ‘Line One.[crlf];Line [...]
Archive of posts tagged TSQL
