ISNULL

Checks to see if a value is null. If the value is null it will return true otherwise false will be returned.

Syntax

bool ISNULL(object value)

Example

The example below uses ISNULL within an IF function to return Value2 if the value is MyColumn is null. Otherwise the original value from MyColumn is returned.

IF(ISNULL(MyColumn), "Value2", MyColumn)