Remove Line Breaks SQL
To remove these SQL line breaks, use the SQL Server replace function. Indeed, the CHAR(13) and CHAR(10) specific codes represent the characters of the line breaks,and then replace them with a space or a comma, for example. This time, the copy paste gives us this result. REPLACE( I.DelAddress ,CHAR(13)+CHAR(10),' ')