Dear all,

I have a problem about VFP to retreive SQL data via ODBC. I checked the option "Use regional settings when outputting currency, numbers, dates and times" on the ODBC driver. Once, I retreive the data from SQL via ODBC, all returned numeric value change to currency format (e.g. 1000 -> 1,000.00). When I display the value of field in VFP, it return 1 for the value. I don't know to uncheck the option on ODBC. Have any way to set the format of return value from Connection String? Thank you very much ....

Best Regards,

Justy Chow