ISNUMERIC

Returns true if the argument is a numeric value.

Syntax

ISNUMERIC ( expression ) 

Arguments

expression
A column expression or value.

Return Type

Returns data of type BOOL.

Examples

Examples in this section use the example blockchain.

The following example returns true if the value from real is a numeric value. Otherwise, it returns false.

SELECT ISNUMERIC(real) FROM example;

Response:

ISNUMERIC(real) [FLOAT32]
false
true
true
true