Verify if the expression is a Null value.
| SELECT IsNull(null); |
The IsNull() function determines if an expression is Null (contains no data).
This function yields a Boolean result: TRUE (-1) indicates the expression is Null, and FALSE (0) indicates it is not Null.
| IsNull(expression) |
|
Parameter |
Description |
|
expression |
Required: The value to be tested |
|
Works in: |
From Access 2000 |
Return TRUE if the expression represents a null value; otherwise, return FALSE.
| SELECT IsNull(“Hello”); |
Return TRUE if the expression is null; otherwise, return FALSE.
| SELECT IsNull(0); |