Description

Returns TRUE if all values are not NULL

Syntax

IS_NOT_NULL(v1[, v]*)

●      v1: a value

●      v: optional additional values

Example

IS_NOT_NULL(Owner)                Owner is NULL        ® FALSE

                                                otherwise                ® TRUE

IS_NOT_NULL(Price, Cost)         Name or ID is NULL ® FALSE

                                                otherwise                ® TRUE

Note

IS_NOT_NULL(First_Name, Last_Name, Phone) is logically equivalent to but more efficient than IS_NOT_NULL(First_Name) AND IS_NOT_NULL(Last_Name) AND IS_NOT_NULL(Phone)

When testing a qualified field’s qualifier values, returns FALSE if there are no qualified links and TRUE if any qualified link has a non-NULL qualifier value. Behavior prior to SP6 was to return FALSE unless all qualified links had non-NULL qualifier values.

To test the inverse of IS_NOT_NULL(), use NOT(IS_NOT_NULL()).