not sure if Oracle supports pattern matching, but you can always try something like (although it looks ugly):substr(字段,1,3) not like '%1%' and substr(字段,1,3) not like '%2%'
and substr(字段,1,3) not like '%3%'
and substr(字段,1,3) not like '%3%'
调试欢乐多
where (instr(substr(columnname,1,3),'1',1) = 0 and instr(substr(columnname,1,3),'2',1) = 0 and instr(substr(columnname,1,3),'3',1) = 0) or columnname is null ;
where substr(column,1,1) not in ('1','2','3')
and substr(column,2,1) not in ('1','2','3')
and substr(column,3,1) not in ('1','2','3')
呵呵,CSDN 5颗星的神仙有几位啊?