请问在SQL Server中如果将数据字段值中的空白字符去掉?

就是字段值有空白,如“张”,但数据库中存储的是“ 张”,如果写SQL语句将这些空白去掉呢?谢谢!
---------------------------------------------------------------

rtrim(ltrim(" zhang "))
---------------------------------------------------------------

rtrim(ltrim(" zhang "))
trim()不能用
---------------------------------------------------------------

rtrim(ltrim(FieldName))

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus