sql server new line replace code example

Example: replace \n sql

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