isnumeric

Description

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