Re: Using the TO_CHAR function in a SQL statement

Okay, but can you write it using the TO_CHAR function?

On Sun, 26 May 2002 20:54:46 GMT, Bricklen Anderson <bricklen_at_shaw.ca> wrote:

>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 - 16:01:40 CDT