use of replace in sql code example Example: replace \n sql SELECT REPLACE(REPLACE(@str, CHAR(13), ''), CHAR(10), '')