modify data on select

[hvle]

I have a table contain a field named 'price' and it is a numeric data.
That field, as you know, hold a numeric number represent an amount of money.

when I do: "select price from table where 1"
it will return the price in numeric form:

234.30
200.00

etc.

The question is, how can I set the query so that it will return

$234.30
$200.00

instead.
how can I have mysql to insert a dollar sign before the data upon return the result?

Thank you very much in advance.

[hvle]

actually, i just found the solution from the manual:

select concat('$',price) as price

Thanks