Create New Line

declare @newline varchar(10)
set @newline = char(13) + char(10)

select 'a' + @newline + 'b'

-- to see the effect use shortcut ctrl + T