IS_NUMERIC_UDF

Description

Determines whether an expression is a valid numeric type. (SQLServer documentation)

SQLServer syntax

ISNUMERIC ( expression )

Custom UDF overloads

Parameters

1. EXPR: A varchar expression that represents the expression to be evaluated as a valid numeric type.

UDF

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

Query

SELECT ISNUMERIC(10);

Result

Snowflake

Query

SELECT
--** MSC-WARNING - MSCEWI1020 - CUSTOM UDF 'IS_NUMERIC_UDF' INSERTED. **
IS_NUMERIC_UDF(10);

Result

Related EWIs

1. MSCEWI1020: CUSTOM UDF INSERTED.