> -----Original Message-----
> From: Ron Rogers [mailto:[EMAIL PROTECTED]]
>
> 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
>
> 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
