Skip to main content
Version: current [24.3.x]

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