> > You can format the values using the functions provided with your
> client.

> I use Delphi as my client. I have been formatting the results in
> Delphi but I thought it would be a good way to optimize if I could
> format the results off the sql. I think I have seen it done with
> msSQL, but maybe not. I'll ask a friend of mine who does a lot

with

> mssql. If he has a solution and it works in Firebird, I'll post it.
>

Well, I don't guess we can do it. He uses CONVERT(NUMERICFIELD AS
CURRENCY) We could do it with CAST, but we don't have the currency
datatype and numeric nor decimal are fixed length. Maybe this should
be put on the wish list.

Dixon