Skip to content
Related Articles

Related Articles

IsNumeric() and IsNull() Function in MS Access
  • Last Updated : 14 Sep, 2020

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
My Personal Notes arrow_drop_up
Recommended Articles
Page :