Verify if the expression can be interpreted as a valid numeric value.
| SELECT IsNumeric(1030); |
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.
| IsNumeric(expression) |
|
Parameter |
Description |
|
expression |
Required: The value to be evaluated |
|
Works in: |
From Access 2000 |
Return TRUE if the expression is recognized as a valid number; otherwise, return FALSE.
| SELECT IsNumeric(“Hello”); |
Return TRUE if the expression is recognized as a valid number; otherwise, return FALSE.
| SELECT IsNumeric(“1030”); |