Replace a newline in TSQL

https://stackoverflow.com/questions/951518/replace-a-newline-in-tsql

Actually a new line in a SQL command or script string can be any of CR, LF or CR+LF. To get them all, you need something like this:

SELECT REPLACE(REPLACE(@str, CHAR(13), ''), CHAR(10), '')