remove any new line charactor from value of column

update emp set name=replace(name,char(10),'') where

charindex(char(10),name)>0