THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access IsNull() Function

❮ MS Access Functions

Example

Check whether the expression is a Null value:

SELECT IsNull(null);
Try it Yourself »

Definition and Usage

The IsNull() function checks whether an expression contains Null (no data).

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

Syntax

IsNull(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 null value, otherwise FALSE:

SELECT IsNull("Hello");
Try it Yourself »

Example

Return TRUE if the expression is a null value, otherwise FALSE:

SELECT IsNull(0);
Try it Yourself »

❮ MS Access Functions