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)