On this page

    Categories: Boolean

    ISNUMERIC

    Determines whether an expression is a valid numeric type (DECIMAL, DOUBLE, INT, BIGINT, VARBINARY).

    Syntax

    ISNUMERIC(expression any) → boolean

    • expression: Can be a general expression of any Dremio-supported data type.

    Examples

    SELECT ISNUMERIC('13579')
    -- True
    
    SELECT ISNUMERIC('Hello World!')
    -- False
    
    SELECT ISNUMERIC(passenger_count)
    FROM "Samples"."samples.dremio.com"."NYC-taxi-trips"
    LIMIT 1 
    
    -- True