Skip to main content

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

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