SET NULLDISPLAY

Class

SQL Applications

Purpose

To specify the text displayed for NULL values

Syntax

SET NULLDISPLAY TO [<expC>]

See Also

ALTER TABLE, CREATE TABLE, EMPTY(), INSERT, ISBLANK(), ISNULL(), NVL(), SET NULL, SET SQL

Description

The SET NULLDISPLAY command is used to specify the text displayed for NULL values. By default NULL values are displayed as .NULL.. The optional <expC> is used to specify alternative display text. If <expC> is omitted, then the display is reset to the default.

Example

set sql to vfp
set null on
set heading off
CREATE TABLE nullon (firstname c(20), lastname c(20))
INSERT INTO nullon (lastname) VALUES ("Smith")
list off
.NULL.    Smith
 
set nulldisplay to "<null>"
list off
<null>    Smith
 
set nulldisplay to
list off
.NULL.    Smith

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer