请我怎么找出表中一个字段A中含有小写英文的记录!

[crazyswan]

比如: 表1 中 字段A,
第三位 和 第七位是 英文字母(大小写都有)
我需要找出所有是小写字母的记录!

[pengdali]

select * from 表1 where ascii(substring(字段A,3,1)) between 97 and 122 and ascii(substring(字段A,7,1)) between 97 and 122

[aierong]

create table 表1( a varchar(100) )
insert into 表1 select '00q000Q00'
insert into 表1 select '00q000q00'
insert into 表1 select '00Q000q00'
go
select *
from 表1
where ascii(substring(a,3,1)) between 97 and 122
and ascii(substring(a,7,1)) between 97 and 122



给你一个例题,你看看

[gmlxf]

select *from yourtalbe where a like '%[a-z]%'