sql查询字段中是否含有字母/数字/符号

CREATE VOLATILE TABLE C (
C1 INTEGER
) PRIMARY INDEX(C1)
;
INSERT INTO C VALUES(‘1‘);
INSERT INTO C VALUES(‘2‘);
INSERT INTO C VALUES(‘3‘);
INSERT INTO C VALUES(‘4‘);
INSERT INTO C VALUES(‘5‘);
INSERT INTO C VALUES(‘6‘);
INSERT INTO C VALUES(‘7‘);

select
    a.id
    ,a.ch
from a a
inner join c c
on length(a.ch) >= c.c1
group by 1,2
having max(case when ascii(substr(a.ch,c1,1)) between ‘97‘ and ‘122‘ then ‘1‘ else ‘0‘ end) = ‘1‘--小写字母的ascii码范围
;
--用where条件也可以
select
　　a.id
　　,a.ch
from a a
inner join c c
on length(a.ch) >= c.c1
where ascii(substr(a.ch,c1,1)) between ‘97‘ and ‘122‘
group by 1,2