sql 判断是否为数字字符

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