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("GeeksforGeeks");

  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("GeeksforGeeks");

  Output –

  0

• Example-2 :

  SELECT IsNull(11);

  Output –

  0

• Example-3 :

  SELECT IsNull(null);

  Output –

  -1