Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

ISNUMERIC (Transact-SQL)

Updated: 12 December 2006

Determines whether an expression is a valid numeric type.

Topic link icon Transact-SQL Syntax Conventions


ISNUMERIC ( expression )

expression

Is the expression to be evaluated.

ISNUMERIC returns 1 when the input expression evaluates to a valid numeric data type; otherwise it returns 0. Valid numeric data types include the following:

int

numeric

bigint

money

smallint

smallmoney

tinyint

float

decimal

real

A return value of 1 indicates that expression can be converted to at least one of the numeric types.

ms186272.note(en-US,SQL.90).gifNote:
   ISNUMERIC returns 1 for some characters that are not numbers, such as plus (+), minus (-), and valid currency symbols such as the dollar sign ($). For a complete list of currency symbols, see Using Monetary Data.

The following example uses ISNUMERIC to return all the postal codes that are not numeric values.

USE AdventureWorks;
GO
SELECT City, PostalCode
FROM Person.Address 
WHERE ISNUMERIC(PostalCode)<> 1;
GO

Release History

12 December 2006

New content:
  • Added the format descriptions for the input expression.

14 April 2006

New content:
  • Added note about additional characters.

Community Additions

ADD
Show:
© 2015 Microsoft