dixonepperson wrote:

> I have a select statement where some of the fields returned are
> numeric(10,2). In my select statment I would like to format the
> numbers as currency.
>
> example if a value stored in the database is 234.5 I would like to
> have that formatted in the result set as 234.50
>
> I've seen it done in mssql, but not sure how to do it in Firebird

You can format the values using the functions provided with your client.
Which client do you use? PHP? Something else?

If you're using PHP check number_format() function...

--
Milan Babuskov
http://fbexport.sourceforge.net
http://njam.sourceforge.net