8. SQL Statements : SET : Money_format
 
Share this page                  
Money_format
SET MONEY_FORMAT specifies the format for monetary output. This option corresponds to the Ingres environment variable II_MONEY_FORMAT and is assigned the same values. The default is L:$. The symbol to the left of the colon indicates the location of the currency symbol--L for a leading currency symbol or a T for a trailing currency symbol. The symbol to the right of the colon is the currency symbol you want displayed. Currency symbols can contain up to four physical characters.
If no currency symbol is required, set the value to NONE (case insensitive).
For example:
Logical Definition
Result
L:$
$100
T:DM
100DM
T:F
100F