bugl
bugl
HomeLearnPatternsPathsSearchPremium
HomeLearnPatternsPaths

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

MS Access IsNull() Function

Example

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

ParameterDescription
expressionRequired. The value to test

Technical Details

Works in:From Access 2000

Previous

MS Access IsDate() Function

Next

MS Access IsNumeric() Function