Create a temporary view and do a type conversion on the Currency column like:
create temp view tTempView as select (FLOAT(CurrencyColumn)), SomeOtherColumns,...,... from SomeTable then do your export. ----- Original Message ----- From: "Joel Solomon" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Friday, February 11, 2005 4:25 PM Subject: [RBG7-L] - Currency Conversion > I need to export a .csv file via gateway. The field in the table is > currency and the output file must not have the $ or ,. This is what I have: > > Amount in my table is $1,000.00 (Currency) > > Amount needed in the output file is 1000.00 > > How do I convert the currency to the correct output format > > Joel Solomon > V.P. Finance > Barbizon International > [EMAIL PROTECTED] >
