Skip to content

isnumeric-transact-sql.md

Latest commit

 

History

History
86 lines (70 loc) · 3.43 KB

isnumeric-transact-sql.md

File metadata and controls

86 lines (70 loc) · 3.43 KB
title ISNUMERIC (Transact-SQL)
description ISNUMERIC (Transact-SQL)
author markingmyname
ms.author maghan
ms.date 03/13/2017
ms.prod sql
ms.technology t-sql
ms.topic reference
f1_keywords
ISNUMERIC
ISNUMERIC_TSQL
helpviewer_keywords
expressions [SQL Server], valid numeric type
numeric data
ISNUMERIC function
verifying valid numeric type
valid numeric type [SQL Server]
checking valid numeric type
dev_langs
TSQL
monikerRange >= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || >= sql-server-linux-2017 || = azuresqldb-mi-current

ISNUMERIC (Transact-SQL)

[!INCLUDE sql-asdb-asdbmi-asa-pdw]

Determines whether an expression is a valid numeric type.

Topic link icon Transact-SQL Syntax Conventions

Syntax

ISNUMERIC ( expression )

[!INCLUDEsql-server-tsql-previous-offline-documentation]

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:

Area Numeric data types
Exact Numerics bigint, int, smallint, tinyint, bit
Fixed Precision decimal, numeric
Approximate float, real
Monetary Values money, smallmoney

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

Examples: [!INCLUDEssSDWfull] and [!INCLUDEssPDW]

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

USE master;  
GO  
SELECT name, ISNUMERIC(name) AS IsNameANumber, database_id, ISNUMERIC(database_id) AS IsIdANumber   
FROM sys.databases;  
GO

See also