REPLACE SQL VARCHAR new line code example

Example: replace \n sql

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