Difference between revisions of "SET NULLDISPLAY"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision: SQL) |
Yvonne.milne (Talk | contribs) |
||
(2 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
To specify the text displayed for NULL values | To specify the text displayed for NULL values | ||
− | |||
==Syntax== | ==Syntax== | ||
SET NULLDISPLAY TO [<expC>] | SET NULLDISPLAY TO [<expC>] | ||
− | |||
==See Also== | ==See Also== | ||
− | [[ALTER TABLE]], [[CREATE TABLE]], [[EMPTY()]], [[INSERT]], [[ISBLANK()]], [[ISNULL()]], [[NVL()]], [[SET NULL]], [[SET SQL]] | + | [[ALTER TABLE]], [[COALESCE()]], [[CREATE TABLE]], [[EMPTY()]], [[IFNULL()]], [[INSERT]], [[ISBLANK()]], [[ISNULL()]], [[NVL()]], [[SET NULL]], [[SET SQL]] |
− | + | ||
==Description== | ==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. | 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== | ==Example== | ||
Line 34: | Line 30: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
[[Category:Set_Commands|NULLDISPLAY]] | [[Category:Set_Commands|NULLDISPLAY]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
− |
Latest revision as of 06:12, 15 April 2013
Contents
Purpose
To specify the text displayed for NULL values
Syntax
SET NULLDISPLAY TO [<expC>]
See Also
ALTER TABLE, COALESCE(), CREATE TABLE, EMPTY(), IFNULL(), 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