Aggregate Functions
-
Date Functions
-
Math Functions
-
Operators
-
Text Functions
-
Window Functions
-
IsNull
Returns True if the argument is Null (does not contain valid data), and False otherwise.
Usage
IsNull(<argument>)
argument (required) Any argument can be provided. The function can analyze one argument at a time. IsNull is often applied to column of data to test for Null values.
Examples
IsNull([Sales])
- Function will return False for rows where sales data exists and True for rows where there is no data.
