Working With Null Values

There are various functions for working with Null values (undefined field contents).

If there are Null values in an expression, the entire expression can become Null. To prevent this, use the "NullSafe()" function for fields that could be empty (e.g. salutation or title). This function checks to see whether the field value is Null and returns a substitute value if this is the case; otherwise, it returns the result of the expression.

Example:

Cond (Empty(COMPANY),NullSafe(SALUTATION) + " " + FIRSTNAME+ " " + NAME)

 

With the "IsNull()" function, you can check whether the value passed to the function or the result of the expression is Null, i.e. an empty field.

Example:

Cond (Empty(COMPANY) or IsNull(COMPANY),FIRSTNAME + " " + NAME)

 

You can set a Null value with the "Null()" function.