SQL Server ISNUMERIC() Function

Posted by

SQL Server

ISNUMERIC()

Function

Example

Tests whether the expression is numeric:

SELECT ISNUMERIC(4567);


Definition and Usage

The ISNUMERIC() function tests whether an expression is numeric.

This function returns 1 if the expression is numeric, otherwise it returns 0.

Syntax

ISNUMERIC(

expression

)

Parameter Values

Parameter Description

expression
Required. The value to test

Technical Details

Works in: SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data
Warehouse, Parallel Data Warehouse

More Examples

Example

Tests whether the expression is numeric:

SELECT ISNUMERIC(‘4567’);

Example

Tests whether the expression is numeric:

SELECT ISNUMERIC(‘Hello world!’);

Example

Tests whether the expression is numeric:

SELECT ISNUMERIC(20*3);

Example

Tests whether the expression is numeric:

SELECT ISNUMERIC(‘2017-08-25’);