FORMAT symbol

Database
Enthusiast

FORMAT symbol

Hi,

I  want to use the FORMAT attribute to display the data in a specified format.

Could anybody tell what do the the following format symbols means:

1) (I)

2) N

3) G

Tags (1)
2 REPLIES
Enthusiast

Re: FORMAT symbol

i also want to know about this formatting symbol meaning. Any help?

Enthusiast

Re: FORMAT symbol

Hi,

Hope this helps

I - Represents the number of characters needed to display the INTEGER portion of numeric data. In the case of a DEC(10,2) data type, I is equivalent to 9(8).

N - Represents FULL CURRENCY NAME. For U.S. applications, this is usually 'U.S. Dollars'.

G - Represents the GROUP SEPARATOR as defined in the SDF. In U.S. applications, this is usually a comma (,) character. It is used to separate digits of the whole number into groups of three or less. It always appears as the first character in a FORMAT string.

Regards

Rajeev