3. Statements : OpenROAD SQL Statements : Set Statement : Money_format
 
Share this page                  
Money_format
Set money_format specifies the format for money 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. It must be "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 and must contain leading and trailing single quotes (for example, 'T:DM').
For example:
Logical Definition
Result
L:$
$100
T:DM
100DM
T:F
100F