Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The following table describes how commands and functions interpret null values.
| Data type | Behavior |
|---|---|
| Logical | Most logical expressions that evaluate to .NULL. return .NULL. or generate an error. EMPTY( ), ISBLANK( ), and ISNULL( ) are exceptions. |
| Numeric | Numeric expressions that evaluate to .NULL. return .NULL. A numeric function evaluates to .NULL. when passed a null value. |
| Date | Date expressions containing null values return .NULL. |
See Also
Null Value Handling | Date Data Type | EMPTY( ) Function | ISBLANK( ) Function | ISNULL( ) Function | Logical Data Type | Numeric Data Type | Behavior of Null Values in Logical Expressions | NULL as a Value | NULL as a Parameter