| Excerpt | ||
|---|---|---|
| ||
ifNull(expression, nullReturnValue) Returns a value depending on whether a supplied expression is _NULL. |
Function: ifNull()
Acts The 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 this is . 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 can be provided that will to run if the first expression is not blank, instead of simply returning the non-null value.
...