Column formatting in exporting SQL result from Access DB

microsoft.public.dotnet.framework

4 Aug 2006 9:24 AM

peterlcf

Dear all,

I would try to export SQL result from Access DB by following SQL
statement:

Select row1 into [Text;DATABASE=c:/tmp].[result.csv] from table1

row1 is in datatype currency.

I have tried this statement and the result shows "HK$ XX.00" for the
column row1. However I don't want to show "HK$" and the decimal place,
i.e. just "XX". How can I get my expected result?

thx in Advance

Peter Leung
Resaonable Software House Ltd.