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给你一个例题,你看看
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给你一个例题,你看看