Column formatting of SQL result export to CSV

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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.

.

Quantcast