Re: Formatting zeroes

Ludwig,

>   I'm trying to use SQL to generate a formatted
> report. The "to_char(numeric,'FM9,999,999,999.99')"
> function works when I use it format numbers with
> decimal points and appropriate commas.
>   Is there a format specifier in the to_char function
> that it will display 0 as "0" or "0.0"?

"to_char(numeric,'FM9,999,999,999.09')"

-Josh Berkus