ISNUMERIC
The ISNUMERIC function determines whether an expression evaluates to a valid numeric type, returning 1 if it is valid and 0 if it is not valid.
Syntax
ISNUMERIC (expression)
Remarks
The following table lists the data types of the evaluated expression for ISNUMERIC and the possible return values.
Data Type of Evaluated Expression | Returns |
CLOB, DATE, DECIMAL, FLOAT, INTEGER, INTERVAL_DAY, INTERVAL_YEAR, NULL, STRING, TIME, TIMESTAMP | 1 |
Any other data type | 0 |
Example
SELECT Contact, Phone, ZipCode
WHERE ISNUMERIC (ZipCode) = 1
FROM /shared/examples/ds_orders/products products