MS Access IsNumeric() Function

Example

Check whether the expression is a valid number:

SELECT IsNumeric(1030);

Definition and Usage

The IsNumeric() function checks whether an expression is a valid number.

This function returns a Boolean value. TRUE (-1) indicates that the expression is a valid number, and FALSE (0) indicates that the expression is not a valid number.

Syntax

IsNumeric(expression)

Parameter Values

Parameter	Description
expression	Required. The value to test

Technical Details

Works in:	From Access 2000

More Examples

Example

Return TRUE if the expression is a valid number, otherwise FALSE:

SELECT IsNumeric("Hello");

Try it Yourself »

Example

Return TRUE if the expression is a valid number, otherwise FALSE:

SELECT IsNumeric("1030");

Try it Yourself »

❮ Previous ❮ MS Access Functions Next ❯