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 Spice-supported data type.

Examples

ISNUMERIC example

SELECT ISNUMERIC('13579')
-- True

ISNUMERIC example

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

ISNUMERIC example

SELECT ISNUMERIC(transaction_count)
FROM eth.recent_blocks 
LIMIT 1 

-- True