select Rtrim(column) from table --去掉右边空格select Ltrim(column) from table --去掉左边空格select replace(column,' ','') from table --去掉所有空格
select replace( 字段名, ' ','') from TableName
