SQL Server

How to remove SQL Server new line?

How to remove SQL Server new line? This post propose a simple SQL Server query to process a string variable and remove the new line character. Technically we replace the new line by nothing. The SQL Server code for a new line is CHAR(13) + CHAR(10). You want to remove it