[Zope-dev] Oracle and MAX

Has anyone used the sql MAX() with Oracle. We were using Sybase and ported to Oracle and it seems that the MAX() in Oracle converts my real numbers to integers this did not happen in Sybase, any thoughts? By the way AVG() does the same SELECT MAX("ItemNumber") FROM SO_Items WHERE "ServiceOrderID" = 1 AND "ItemNumber" < 2 The ItemNumber is a number(9,3) in the table SO_Items. By the way the sql code works fine in sqlplus.