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.
SET @Note = 'Line One.[crlf];Line Two[crlf]Line Three.'
SET @Note = REPLACE(@Note,'[crlf]',CHAR(13)+CHAR(10))