去掉字段中的空格但英文字段不去空格
时间:2015-03-09 23:17 来源:linux.it.net.cn 作者:IT
update aaa set
name = replace(name,' ','')
where Unicode(ltrim(name)) <> ASCII(ltrim(name))
update tab1 set
name = rtrim(ltrim(name))
where Unicode(ltrim(name)) = ASCII(ltrim(name))
(责任编辑：IT)
| update aaa set name = replace(name,' ','') where Unicode(ltrim(name)) <> ASCII(ltrim(name)) update tab1 set name = rtrim(ltrim(name)) where Unicode(ltrim(name)) = ASCII(ltrim(name)) (责任编辑：IT) |