IS_NUMERIC_UDF
Description
Determines whether an expression is a valid numeric type. (SQLServer documentation)
SQLServer syntax
ISNUMERIC ( expression )
Custom UDF overloads
Parameters
EXPR: A varchar expression that represents the expression to be evaluated as a valid numeric type.
CREATE OR REPLACE FUNCTION IS_NUMERIC_UDF(EXPR VARCHAR)
RETURNS INTEGER
LANGUAGE sql
IMMUTABLE
as
$$
SELECT CASE WHEN TRY_TO_NUMERIC(EXPR) IS NULL THEN 0 ELSE 1 END
$$;
SQL Server
SELECT ISNUMERIC(10);
Snowflake
SELECT
--** MSC-WARNING - MSCEWI1020 - CUSTOM UDF 'IS_NUMERIC_UDF' INSERTED. **
IS_NUMERIC_UDF(10);
Related EWIs
MSCEWI1020: CUSTOM UDF INSERTED.
Last updated
Was this helpful?