MSSQL – Remove new line character from varchar Vis Dotnet 2 years ago select Replace(Name, CHAR(10), ”) from Test1