MSSQL – Remove new line character from varchar SQL 15/10/2022 select Replace(Name, CHAR(10), ”) from Test1