RE: select question

My
thought entirely - or to enhance slightly more, as you have quite a large number pre-decimal place:
<FONT face=Arial color=#0000ff

size=2> 
<FONT face=Arial color=#0000ff

size=2>to_char(total, '$9,999.99')
<FONT face=Arial color=#0000ff

size=2> 
<FONT face=Arial color=#0000ff

size=2>or
<FONT face=Arial color=#0000ff

size=2> 
<FONT face=Arial color=#0000ff

size=2>to_char(total, 'FM$9,999.99') as Jacques suggested..
<FONT face=Arial color=#0000ff

size=2> 
This
will give you a slightly better output format, with a comma every 3 numbers.
<FONT face=Arial color=#0000ff

size=2> 
<FONT face=Arial color=#0000ff

size=2>HTH
<FONT face=Arial color=#0000ff

size=2> 
<FONT face=Arial color=#0000ff

size=2>Mark

  <FONT face=Tahoma
  size=2>-----Original Message-----From: root_at_fatcity.com   [mailto:root_at_fatcity.com]On Behalf Of Jacques KilchoerSent:   Thursday, May 31, 2001 10:27To: Multiple recipients of list   ORACLE-LSubject: RE: select question
  > -----Original Message----- >
  From: Ron Rogers [<A
  href="mailto:RROGERS_at_galottery.org">mailto:RROGERS_at_galottery.org]   > > If you know the size of the
  number (in position count not > value) you can use   the RPAD(sum(field),count,0) to populate > the   right end of the return value to zero.  > ex.   the sum value is = 2.5 and you want 2.50 >   rpad(sum(fd1,4,'0') return 2.50 > <FONT   size=2>> BUT if the return value = 25.5 and you want 25.50 and have   > used the 2.50 rpad(sum(fd1,4,'0')  the   return 25.5  will be > returned. You could   always use > 2.50 rpad(sum(fd1,6,'0') and then drop   the unneeded zeroes.
  Am I missing something? Why not use to_char (number_field,   '99.99')? or to_char (number_field, 'FM99.99') to   eliminate leading and trailing blanks in the formatted number Received on Fri Jun 01 2001 - 06:07:05 CDT