ISNUMERIC Function

Determines whether a given value is or can be converted to a numeric data type.

Syntax

ISNUMERIC(value)

Parameters

• value: scalar
  The value to inspect.

Return Value

If the value can be converted to a numeric data type, then 1 is returned. If not, then 0 is returned.

Example

PRINT ISNUMERIC('A');  -- "0"
PRINT ISNUMERIC('123');  -- "1"
PRINT ISNUMERIC(3.14);  -- "1"