nvarchar 删除 tab 空格

update PersonInfo set   PersonFamilyInf=REPLACE(PersonFamilyInf, CHAR(13) , '')    
update PersonInfo set   PersonFamilyInf=REPLACE(PersonFamilyInf, CHAR(10) , '')   
update PersonInfo set   PersonFamilyInf=REPLACE(PersonFamilyInf, CHAR(9) , '') 

删除 回车,换行,tab 空格,

原文地址:https://www.cnblogs.com/gwazy/p/2789412.html