Hello,
I'm getting weird characters returned for numberic fields.

Current Format
+000000000000001.2485

Expected Format
1.2485

Below is the export command I'm using. Can someone advise on how to format numeric fields correctly?

export to c:\test\txn2011.txt of del modified by COLDEL0x09 NOCHARDEL SELECT Partner, Profit FROM SchoolBudget;

that is the correct format. If you'd like it in a different format, you would have to change the data type on the select statement. Something like:

SELECT Partner, strip(digits(Profit),l,'0') FROM SchoolBudget

Dave