Curriculum
Course: SQL
Login

Curriculum

SQL

SQL References

0/80

MySQL Functions

0/139

SQL Server Functions

0/84

SQL Quick Ref

0/1
Text lesson

IsNumeric

Example

Verify if the expression can be interpreted as a valid numeric value.

SELECT IsNumeric(1030);

Definition and Usage

The IsNumeric() function assesses whether an expression is a recognized numeric value.

It returns a Boolean outcome: TRUE (-1) signifies the expression is a valid number, while FALSE (0) signifies it is not.

Syntax

IsNumeric(expression)

Parameter Values

Parameter

Description

expression

Required: The value to be evaluated

Technical Details

Works in:

From Access 2000

More Examples

Example

Return TRUE if the expression is recognized as a valid number; otherwise, return FALSE.

SELECT IsNumeric(“Hello”);

Example

Return TRUE if the expression is recognized as a valid number; otherwise, return FALSE.

SELECT IsNumeric(“1030”);