RE: Forcing 2 Decimal Positions

[Burton, Laura L.]

Title: Forcing 2 Decimal Positions

Thanks.  This worked wonderfully!!   -----Original Message----- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 1:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: Forcing 2 Decimal Positions   select to_char(your_number, '0000.90')   from dual /   Raj ------------------------------------------------------------- Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -----Original Message----- From: Burton, Laura L. [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 1:54 PM To: Multiple recipients of list ORACLE-L Subject: Forcing 2 Decimal Positions 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. Thanks in advance! Laura