update table set fa=replace(fa,chr(13),”) ; — 除去回车符
update table set fa=replace(fa,’ ‘,”) ; — 除去空格符
我们的例子
select user_nm,user_code,length(user_code),length(replace(replace(user_code,chr(9),”),’ ‘,”)) from flow_user where length(replace(replace(user_code,chr(9),”),’ ‘,”))!=length(user_code); 阅读全文 »
