Remove white spaces in column value in sql

Remove white spaces in column value  in sql

update TableName set ColumnName= lTrim(rTrim(ColumnName))

Remove new line in column values in SQL Server

Remove new line in column values in SQL Server

declare @NewLine char(2)
set @NewLine=char(13)+char(10)

UPDATE TableName
SET ColumnName=Replace(ColumnName, @NewLine,'')
WHERE ColumnName like '%' +@NewLine +'%'