Using ZSQLMethods against an ORACLE 8.0.6 Database. I have two tables, each with a NUMBER(6) key field. If I create a method which selects against each of the tables then method returns an integer (e.g. 5040), as expected. select index_number from names where name = 'name' or select index_number from aliases where alias = 'name' If I attempt to get the combined list select index_number from names where name = 'name' union select index_number from aliases where alias = 'name' I get a float back (e.g. 5040.0). Is this expected/correct? If so how do I force it to return the integer. David Cooper [EMAIL PROTECTED] _______________________________________________ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )