| Name: | NULL | Default: | Dash-Zero-Dash (-0-) |
|---|---|---|---|
| Family: | SET Parameter | Category: | Special Character |
| Description: | Controls value that is displayed when a NULL value is encounted. | ||
NULL's are used to represent unknown or missing data and SET NULL changes the display symbol for null. You can use up to four characters. If you set null to a blank space, R:BASE does not display rows composed entirely of nulls with the SELECT command. R:BASE stores the NULL setting with the database. When referring to null in commands it is preferential to use the NULL keyword as opposed to a given representation of NULL.
If you enter the following command, R:BASE displays a slash in the absence of data:
SET NULL /