摆不平了~谁给看看~,解决马上给分~

在SqlServer库中,比如设置一个姓名字段,类型为Char,长度为20,在输入数据后,如果不足20个字符,它会在后边加上空格,我现在不想要后边的空格,对我处理程序来说很不方便~,请问如何解决?
---------------------------------------------------------------

select rtrim(uName) from yourTable

如果去掉左邊的空格用 ltrim(uName)
如果去掉兩邊的用ltrim(rtrim(uName))
---------------------------------------------------------------

改成VARCHAR(20)
或用:select rtrim(姓名) from
---------------------------------------------------------------

why not use
varchar(20)
---------------------------------------------------------------

用varchar类型

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