SET NULLDISPLAY Command

Specifies the text displayed for null values.

SET NULLDISPLAY TO [cNullText]

Parameters

  • cNullText
    Specifies the text that is displayed for null values. If cNullText is omitted, the default null value text, .NULL., is restored and displayed for null values.

Remarks

By default, Visual FoxPro displays .NULL. for null values in objects, Browse windows, DISPLAY output, LIST output, and so on. Use SET NULLDISPLAY to change the default null value text to a different character string. SET NULLDISPLAY changes the default null value text for all objects for which the NullDisplay property is the empty string.

Use the NullDisplay property to change the default null value text to a different character string for an individual object.

See Also

CREATE TABLE - SQL, | SQL NullDisplay Property | SET NULL Command