isnumeric

Determines if an expression is a valid numeric datatype.

Syntax

isnumeric (character_expression)

Parameters

Examples

Usage

  • Returns 1 if the input expression is a valid integer, floating point number, money or decimal type; returns 0 if it does not or if the input is a NULL value. A return value of 1 guarantees that you can convert the expression to one of these numeric types.

  • You can include currency symbols as part of the input.