查找包含有中文和全角的字段

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 'ｒｅｓｔ'
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))))

[@more@]