IsNumeric() and IsNull() Function in MS Access
1. IsNumeric() Function :
IsNumeric() Function in MS Access is used to check whether an expression can be evaluated as a number. It returns TRUE (-1) means that the expression can be recognized as a number; otherwise, it returns False(0).
Syntax :
IsNumeric(expression)
Parameter – Required; An expression.
expression – It is any variant containing a numeric expression or a string expression.
Returns – It returns True(-1) if the entire expression is recognized as a number, otherwise it returns False(0).
- Example-1 :
SELECT IsNumeric("w3wiki");
Output –
0
- Example-2 :
SELECT IsNumeric(111);
Output –
-1
Note : IsNumeric returns False if expression is a date expression.
- Example-3 :
SELECT IsNumeric(#11/09/2020#);
Output –
0
2. IsNull() Function :
IsNull() Function in MS Access is used to check whether the expression is a Null value. It returns TRUE (-1) means that the expression is a Null value, and FALSE (0) indicates that the expression is not a Null value.
Syntax :
IsNull (expression)
Parameter – Required; An expression.
expression – It is any variant containing a numeric expression or string expression.
Returns – It returns True(-1) if expression is Null, otherwise it returns False(0).
- Example-1 :
SELECT IsNull("w3wiki");
Output –
0
- Example-2 :
SELECT IsNull(11);
Output –
0
- Example-3 :
SELECT IsNull(null);
Output –
-1
Contact Us