Skip to main content
Version: 0.0.1

ISNUMERIC

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

{{< codeheader "ISNUMERIC example" >}}

SELECT ISNUMERIC('13579')
-- True

{{< codeheader "ISNUMERIC example" >}}

SELECT ISNUMERIC('Hello World!')
-- False

{{< codeheader "ISNUMERIC example" >}}

SELECT ISNUMERIC(passenger_count)
FROM "Samples"."samples.dremio.com"."NYC-taxi-trips"
LIMIT 1 

-- True