谁说没有replace函数，是不是写错了update yzh set zh=replace(zh,' ','')
放在sql语句外面zh=replace(zh," ","") UPDATE yzh SET zh = trim([zh]);
用replace函数,replace(zh," ","")
用记录集来做吧！~~
