How do I force display of a FLOAT in a format like
Original number Result 1234.34 1234.340 12345.456 12345.456 123.1 123.100 123 123.000 The dev on a project wants to preformat the data for a report on the database side. He wants 3 places after the decimal to display even if the number is a whole number.... (I know most VB report controls do this easily....but...) I thought it was complicated as it would require a to_char with format description then searching for the postion of the decimal and then moving from there to the right counting the characters if the number of characters to the right of the decimal was < 3 then pad with zeros... I messed around with RPAD, TRUNC, ROUND and TO_CHAR and found I was not able handle all cases of possible significant digits. Sounded like a complicated function to do something thats automagic in a reporting control. Or am I forgetting a oracle function....or fomat? This is 8.1.7.... I told the developer to use the field formatting contols of his reporting control because the additional zeros padded in a number are basically meaningless in a database and mathematical operations. Brad O. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
