MSSQL – Remove new line character from varchar



select Replace(Name, CHAR(10), ”) from Test1