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.

Character

Meaning

@

A character


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

Examples

This format mask:

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

displays the string 800YESCELT in red as:

(800) YES-CELT