(SUBSTR(字段,1,1) between 'a' and 'z' or
SUBSTR(字段,2,1) between 'a' and 'z' or
SUBSTR(字段,3,1) between 'a' and 'z' or
SUBSTR(字段,4,1) between 'a' and 'z')
and
SUBSTR(字段,6,1) not in('L','S')
SUBSTR(字段,2,1) between 'a' and 'z' or
SUBSTR(字段,3,1) between 'a' and 'z' or
SUBSTR(字段,4,1) between 'a' and 'z')
and
SUBSTR(字段,6,1) not in('L','S')
SUBSTR(字段,1,4) between '000A' and 'zzzz'
and
SUBSTR(字段,6,1) not in('L','S')