gusucode.com > 精典源码Delphi062：化工颜料生产管理(商业源码)源码程序 > 精典源码Delphi062：化工颜料生产管理(商业源码)源码程序/精典源码Delphi062：化工颜料生产管理(商业源码)/化工颜料生产管理/lds-source/doc/查询色粉配方编码中首字母为字母.txt

    查询色粉配方编码中首字母为字母
select * from make_up_head where  (ASCII(SUBSTRING(muh_code,1,1)) >= 65 and ASCII(SUBSTRING(muh_code,1,1)) <= 90 or ASCII(SUBSTRING(muh_code,1,1)) >= 97 and ASCII(SUBSTRING(muh_code,1,1)) <= 122) order by muh_code

查询色粉配方编码中首字母为非字母
select * from make_up_head where  (ASCII(SUBSTRING(muh_code,1,1)) < 65 or ASCII(SUBSTRING(muh_code,1,1)) > 90 and ASCII(SUBSTRING(muh_code,1,1)) < 97 or ASCII(SUBSTRING(muh_code,1,1)) > 122) order by muh_code