是否存在可以在列中查找非整数的sql条件？ [英] Is there an sql condition that can look for non integers in a column?

问题描述

基本上，我希望选择一条语句，其功能如下：

Basically I would like a select statement that would function like this

SELECT *
FROM table  
WHERE column IS NOT INT  

是否存在类似情况或如何检查非整数在nvarchar（10）列中？

Is there a condition like this or how do you check for non-integers in an nvarchar(10) column?

推荐答案

在 SQL Server 中，您可以做到：

SELECT  *
FROM    mytable  
WHERE   CASE WHEN IsNumeric(mycolumn) = 1 THEN CASE WHEN CAST(mycolumn AS FLOAT) <> CAST(CAST(mycolumn AS FLOAT) AS INT) THEN 1 END ELSE 1 END = 1

这篇关于是否存在可以在列中查找非整数的sql条件？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！