RE: How can I do this better/best

David,
Not sure if it's "best", but easiest is to just
Play with the formatting (this way you don't
Have to look for the decimal):

SQL> select to_char(9,'fm9999999.00')||'%' from dual;

TO_CHAR(9,'F

9.00%

SQL> select to_char(10,'fm9999999.00')||'%' from dual;

TO_CHAR(10,'

10.00%

SQL> select to_char(375,'fm9999999.00')||'%' from dual;

TO_CHAR(375,

375.00%

SQL> select to_char(375.99,'fm9999999.00')||'%' from dual;

TO_CHAR(375.

375.99%

hope that helps,
Anthony

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David
Sent: Thursday, March 17, 2005 10:00 AM
To: oracle-l_at_freelists.org
Subject: How can I do this better/best