14 out of 23 rated this helpful - Rate this topic

ISNUMERIC (Transact-SQL)

SQL Server 2012

Determines whether an expression is a valid numeric type.

Topic link icon Transact-SQL Syntax Conventions

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

Reference

Expressions (Transact-SQL)

System Functions (Transact-SQL)

Data Types (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD