Hi All,

Is it possible to format the results of a sql select?

The following creates a table but I'd like the serv_fee results to be formatted slightly differently than the table it's based on.

select tablename.serv_fee as serv_fee, from tablename into sqltable nofilter.

In the original table the field is numeric 9 but I want the output to show as numeric 9 2 as it is being used in a "word" document to represent currency.

example:

tablename.serve_fee = 10000

sqltable.serv_fee = 10,000.00

I tried transform but this was illegal, at least I got an error message.

select tablename.serv_fee as transform(serv_fee,'99,999.99')

Any help would be appreciated.

TIA.

Jim Harvey
jharvey@netrax.net (office)
jeh@gscyclone.com (home)