remove any space from any value of column

update emp set name=replace(name,' ','') where charindex('

',name)>0