From Jacques.Kilchoer@quest.com Thu, 31 May 2001 14:12:59 -0700 From: Jacques Kilchoer Date: Thu, 31 May 2001 14:12:59 -0700 Subject: RE: select question Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: RE: select question > -----Original Message----- > From: Ron Rogers [mailto:RROGERS@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 > > 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