That's funny, the 00 works for me. See example below (note that my decimal parameter is "," not "." because of my local settings)
SQL> select
2 price,
3 to_char (price, '90D00') as price2
4 from
5 (select 20 as price from dual
6 union all
7 select 20 / 3 as price from dual
8 union all
9 select 20 / 8 as price from dual
10 union all
11 select 20 / 16 as price from dual
12 union all
13 select 20 / 32 as price from dual
14 ) ;
PRICE PRICE2
--------- ------
20 20,00
6,6666667 6,67
2,5 2,50
1,25 1,25
,625 0,63
-----Original Message-----
From: Burton, Laura L. [mailto:[EMAIL PROTECTED]]
I know this must be extremely simple, but the only thing I can find for this is column format and that doesn't work, so could someone tell me how to force an amount field to show 2 decimal positions? I have tried format 999.99 and 990.00 but it will not print the zero if it is after the decimal ( i.e. 100.5 or 88 ). I know I have done this before but I guess I have gone brain dead.
