update jbxx set 地号=replace(地号,' ','' ) 转载于:https://www.cnblogs.com/MyBeN/archive/2012/09/10/2679049.html