update tablename set 字段名=ltrim(rtrim(字段名))
Update tablename Set 字段名=Replace(字段名,' ','')
replace('字段,char(13)+char(10),'')