sql remove new line characters code example

Example: replace \n sql

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