就是字段值有空白,如“张”,但数据库中存储的是“ 张”,如果写SQL语句将这些空白去掉呢?谢谢!
---------------------------------------------------------------
rtrim(ltrim(" zhang "))
---------------------------------------------------------------
rtrim(ltrim(" zhang "))
trim()不能用
---------------------------------------------------------------
rtrim(ltrim(FieldName))