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
SELECT ISNUMERIC('13579')
-- True
SELECT ISNUMERIC('Hello World!')
-- False
SELECT ISNUMERIC(transaction_count)
FROM eth.recent_blocks
LIMIT 1
-- True
Last updated
Was this helpful?