create table T (a nvarchar(40),name varchar(50))
insert into T(a) select '我a'
insert into T(a) select 'dasda'
insert into T(a) select 'a人'
insert into T(a) select 'rest'
insert into T(a) select 'COLLATE76保险'
select *,datalength(ltrim(rtrim(convert(varchar(40),a)))),
len(ltrim(rtrim(convert(varchar(40),a)))) ,
datalength(a),
len(a)
from T
where datalength(ltrim(rtrim(convert(varchar(40),a))))>len(ltrim(rtrim(convert(varchar(40),a))))
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7192349/viewspace-1008082/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7192349/viewspace-1008082/