Mask

Character

Description

a

Accepts any alphabetic character.

A

Accepts any alphabetic character and forces upper case.

N

Accepts any numeric character (+, -, 0..9, ., ,).

x

Accepts any character.

X

Accepts any character, forces lower case alphabetic characters to upper case.

z

Accepts any alphanumeric character.

Z

Accepts any alphanumeric character, forces lower case alphabetic characters to upper case.

U

Any digit, alphabetic, or punctuation character. Converts lower-case alphabetic characters to upper case.

0

Numeric formatted, zero filled.

#

Numeric formatted, space filled.

*

Numeric formatted, asterisk filled.

,

Thousands separator if found before ".". Decimal point if found after ".".

.

Thousands separator if found before ",". Decimal point if found after ",".