...

Function: ifNull()

Returns a value depending on whether a supplied expression is _NULLThe ifNull function acts as a simple IF statement to determine what to do when the supplied expression is _NULL. It checks the value returned by the first expression. If the returned value is:

• _NULL, the second expression runs
• not _NULL, the value in the initial expression is used.

You can provide an optional third expression to run if the first expression is not blank, instead of simply returning the non-null value.

Syntax

1. ifNull(expression, nullReturnValue)
2. ifNull(expression, nullReturnValue, notNullReturnValue)

...