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

ISNUMERIC example

SELECT ISNUMERIC('13579')
-- True

ISNUMERIC example

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

ISNUMERIC example

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