Group Null and NIL
Coalesce()
Returns the first non NIL/NULL expression among its arguments.
Coalesce( <Expression,...> ) --> <Expression>
CoalesceEmpty()
Returns the first non empty expression among its arguments.
CoalesceEmpty( <Expression,...> ) --> <Expression>
DbSetNullValue()
Toggles NULL/NIL value support of a work area
DbSetNullValue([<lNullAllowed>]) -> lNullAllowed
IsNull()
Tests if an expression evaluates to NULL/NIL.
IsNull( <Expression> ) --> lIsNull IsNull( <Expression>, <ReplacementValue> ) --> xValue
NullIf()
Returns a NIL/NULL value if the two specified expression values are equivalent
NullIf( <Expression>, <Expression> ) --> lEqual
SET NULLVALUE
Enables/Disables NULL/NIL values for fields
SET NULLVALUE ON | off | <lToggle>