isnumeric

Determines if an expression is a valid numeric datatype.

Syntax

isnumeric (character_expression)

Parameters

character_expression – is a character-type variable, constant expression, or a column name.

Examples

Example 1 – Determines if the values in the postalcode column of the authors table contains valid numeric datatypes:
```
select isnumeric(postalcode) from authors
```
Example 2 – Determines if the value $100.12345 is a valid numeric datatype:
```
select isnumeric("$100.12345")
```

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.

Parent topic: Transact-SQL Functions

Created May 28, 2014. Send feedback on this help topic to Technical Publications: pubs@sap.com