>>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')
>
>Slightly different (you were close, though):
>
>select transform(tablename.serv_fee,'99,999.99') as s_fee
>
>Of course, you'll get a string, but that's what you wanted, right?
Hi Dragan,
Thanks, it works just fine, I appreciate the help.
Jim