Re: Forcing 2 Decimal Positions

[Arup Nanda]

Title: Forcing 2 Decimal Positions

Laura,   It woroks for me.   SQL> select to_char(clusterid,'99999.90') from t;   TO_CHAR(C ---------   1234.89   1234.80   SQL> select clusterid from t;    CLUSTERID ----------    1234.89     1234.8   SQL> col clusterid format 99999.90 SQL> /   CLUSTERID ---------   1234.89   1234.80   HTH.   Arup ----- Original Message ----- From: Burton, Laura L. To: Multiple recipients of list ORACLE-L Sent: Wednesday, March 12, 2003 1:54 PM 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