Re: Using the TO_CHAR function in a SQL statement

why use the to_char function? why not rewrite it as so:

SELECT item_id,'$'||round(sum(price * qoh),2) "Inv. Value" FROM inventory
GROUP BY item_id;

jkutey_at_nospam.nycap.rr.com wrote:
>
> Here is my query:
>
> select item_id, sum(price*qoh) "Inv. Value"
> FROM inventory
> group by item_id;
>
> How would I write this query using the TO_CHAR function to format the
> number values using a currency format masked with two decimal places?
>
> Thanks
> John
Received on Sun May 26 2002 - 15:54:46 CDT