update table set field = replace(replace(replace(field,char(9),''),char(10),''),char(13),'');
update table set field = replace(replace(replace(field,char(9),''),char(10),''),char(13),'');
转载于:https://www.cnblogs.com/mr-wuxiansheng/p/10954482.html