Is there a database agnostic way to perform an ISNUMERIC check in a query?

48 Views Asked by At

I have a query like below. I may be switching between SQL Server, Oracle etc. Is there a database agnostic way to perform an ISNUMERIC check in a query?

SELECT name 
FROM Students 
WHERE ISNUMERIC(columnName) = 0

I tried using REGEXP_LIKE and similar things but they all favour certain DB types and not others.

0

There are 0 best solutions below