NULL
Top  Previous  Next

Special Character

Syntax: SET NULL -0- (1 to 4 characters)

Default: -0-

SET NULL sets 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 setting with the database.

If you enter the following command, R:BASE displays a slash in the absence of data:
 
SET NULL /