select * from table_A where 1=1
AND PATINDEX('%[^0-9|.|-|+]%',clo) = 0
AND ISNUMERIC(clo) = 1
SQL Server中校验过滤出数字类型的字符
最新推荐文章于 2023-01-28 20:32:20 发布
select * from table_A where 1=1
AND PATINDEX('%[^0-9|.|-|+]%',clo) = 0
AND ISNUMERIC(clo) = 1