# 字段是否以數(shù)字開頭
SELECT EMPLOYEE,DAYS FROM EMPLOYEE WHERE SUBSTR(EMPLOYEE_ID,1,1) BETWEEN '0' AND '9';
# 字段內(nèi)部是否包含數(shù)字
SELECT * FROM EMPLOYEE WHERE REGEXP_LIKE (EMPLOYEE_ID,'^[0-9]+[0-9]$');
文章名稱：SQL判斷字段是否以數(shù)字開頭或者包含數(shù)字
文章轉(zhuǎn)載：
http://m.jiaotiyi.com/article/gcsspo.html