SQL Reference Guide

ISNUMERIC function

Syntax

ISNUMERIC( expr )

Description

The scalar function ISNUMERIC returns 1 if the input expression evaluates to an exact numeric or approximate numeric type; otherwise it returns 0. A return value of 1 guarantees that expr can be converted to one of these numeric types.

Arguments

• expr - Is an expression to be evaluated.

Example

SELECT ISNUMERIC(id), ISNUMERIC(tbl) FROM systables

WHERE tbl = 'systables';

ISNUMERIC(ID ISNUMERIC(TB

------------ ------------

1 0