Using string display formats

Applies to

Display formats

Description

A string display format can have two sections. The first section is required. The second section is optional and specifies how to represent NULLs.

string-format;null-format

The following table shows characters that have special meaning in string display formats.

Table 4-7: Special characters in string display formats

Character

Meaning

@

A character

All other characters (including spaces) display as entered in the mask.

Examples

Example 3

This format mask:

[red](@@@) @@@-@@@@

displays the string 800YESCELT in red as:

(800) YES-CELT