NULL is a special Oracle value that may be applied to all data types. It means that the value is unknown. Therefore: * Any IF condition evaluation with NULL will __always__ return False * a NULL value must be tested for explicitly, in SQL, as thus: IS NULL or IS NOT NULL * Oracle provides for functions to handle Null conditions like [NVL] * UserCalcs can test for Null conditions using the [EQNL|EQNL_OPERATOR] Operator ---- ![Notes|Edit:Internal.NULL] [{InsertPage page='Internal.NULL' default='Click to create a new notes page'}]