首页 > 代码库 > 坑爹的SQL ISNUMERIC

坑爹的SQL ISNUMERIC

select ISNUMERIC(‘01,02‘)

  

ISNUMERIC返回 1,后面用patindex代替了。。。折腾/

 

select patindex(‘%[^0-9]%‘,‘01,02‘)

  

坑爹的SQL ISNUMERIC