Previous Topic: Insertion CharactersNext Topic: Examples


Signs and Symbols

You can specify only one type of sign character or currency symbol in an edit pattern. You can specify a sign only in the rightmost position of the edit pattern. A currency symbol can be only in the leftmost position of the edit pattern.

$

Specifies that a dollar sign currency symbol is to appear with the value when displayed. If you use this symbol more than once in succession, it becomes a floating character. A floating character specifies that the dollar sign is to appear left of the leftmost digit in the value. To specify a floating character, use multiple dollar signs in the edit pattern in each digit position through which it can float.

Specifies that a euro currency symbol is to appear with the value when displayed. If you use this symbol more than once in succession, it becomes a floating character. A floating character specifies that the euro symbol is to appear left of the leftmost digit in the value. To specify a floating character, use multiple euro symbols in the edit pattern in each digit position through which it can float.

-

Specifies that the minus sign is to appear only if the value of the column is less than zero. If the value is greater than zero, no sign appears.

CR

Specifies that the credit symbol is to appear only if the value is less than zero.

DB

Specifies that the debit symbol is to appear only if the value is less than zero.