ISNUMERIC (Transact-SQL)
Determines whether an expression is a valid numeric type.
.gif "Topic link icon")
Transact-SQL Syntax Conventions
Syntax
ISNUMERIC ( expression )
Arguments
- expression
Is the expression to be evaluated.
Return Types
int
Remarks
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 |
Note
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 money and smallmoney (Transact-SQL).
Examples
The following example uses ISNUMERIC to return all the postal codes that are not numeric values.
USE AdventureWorks2012;
GO
SELECT City, PostalCode
FROM Person.Address
WHERE ISNUMERIC(PostalCode)<> 1;
GO