IF_NULL Function

Parameters: (String <test value>, String <return if NULL>, String <return if not NULL>);

Returns: String;

Function to return a value based on whether a string is NULL or not. An empty string is considered to be NULL.

The first parameter is the value to be checked to see if it is NULL (or an empty string)

The second parameter is the value that will be returned if the test value is NULL or empty.

The third parameter is the value that will be returned if the test value is NOT NULL.

Examples:

Example 1: IFNULL('Hello World', 'TRUE', 'FALSE') = 'TRUE'

Example 2: IFNULL('', 'TRUE', 'FALSE') = 'FALSE'