sql 判断是否为数字字符
时间：2011-03-14 来源：小锋神
SELECT * FROM TableName WHERE A LIKE '%[^0-9]%'--非数字
select * from tbl_order where (substring(product_no,1,1)) not LIKE '%[^0-9]%'
SELECT * FROM TableName WHERE A NOT LIKE '%[^0-9]%'--数字
select * from biao where ISNUMERIC(ziduan)=1
相关阅读 更多 +
