bugl
bugl
HomeLearnPatternsSearch
HomeLearnPatternsSearch

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

MS Access IsNull() Function

Concept visual

MS Access IsNull() Function

Pointer walk
two pointers
leftright102132436485116
left=0
right=6
1
3

Start at both ends

Example

Check whether the expression is a Null value:

SELECT IsNull(null);

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

Example

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

SELECT IsNull(0);

Previous

❮ MS Access Functions

Next

Previous

MS Access IsDate() Function

Next

MS Access IsNumeric() Function