The database I'm running the query against is Firebird 1.5, the field in question is defined as a float. I've got a third party ODBC driver from IBPhoenix
http://www.ibphoenix.com/main.nfs?page=ibp_60_odbc
Will try the suggestion you've made and see if it does the trick,
Thanks