| 解决方案： |
快速的更改办法可参考：
update inventory
set cinvname=replace(cinvname,' ',''),cinvstd=replace(cinvstd,' ','')
update inventory set cinvname=replace(cinvname,'(',''),cinvstd=replace(cinvstd,'(','')
update inventory set cinvname=replace(cinvname,')',''),cinvstd=replace(cinvstd,')','')
update inventory set cinvname=replace(cinvname,'[',''),cinvstd=replace(cinvstd,'[','')
update inventory set cinvname=replace(cinvname,']',''),cinvstd=replace(cinvstd,']','')
update inventory set cinvname=replace(cinvname,'{',''),cinvstd=replace(cinvstd,'{','')
update inventory set cinvname=replace(cinvname,'}',''),cinvstd=replace(cinvstd,'}','')
update inventory set cinvname=replace(cinvname,'*',''),cinvstd=replace(cinvstd,'*','')
update inventory set cinvname=replace(cinvname,'#',''),cinvstd=replace(cinvstd,'#','')
update inventory set cinvname=replace(cinvname,'-',''),cinvstd=replace(cinvstd,'-','')
update inventory set cinvname=replace(cinvname,'.',''),cinvstd=replace(cinvstd,'.','')
再查询就可以。 |