I vaguely remember that you can pass some attributes to prepare or bind to help DBI / DBD::ODBC with the correct data types. In your case, you need to mark the result column as floating point number (instead of int / string). See bind_col in DBD::ODBC.

In general, DBI / DBD::ODBC should be able to auto-detect the type of any result column, but it seems that something got messed up with FoxPro. Perhaps FoxPro wrongly reports the column as some integer type at the ODBC level.

Alexander