去除特殊字符
- char(9)制表符
- char(10)换行
- char(13)回车
update table set field = replace(replace(replace(field,char(9),''),char(10),''),char(13),'');
去除前后空白字符
update table set field = TRIM(field);
去除特殊字符
update table set field = replace(replace(replace(field,char(9),''),char(10),''),char(13),'');
去除前后空白字符
update table set field = TRIM(field);