Everybody: This is part of the SQL that I see in the SQL_AREA (oracle v9) between DATE '01-JUN-06' and DATE '14-JUN-06' and T5.BUS_UNT_CDE1='MS' and I have never seen the DATE keyword used like that before. Is that something that was added in Oracle9. I tried executing it manually but it keeps failing. any insight? thank you Gene Gurevich -- //www.freelists.org/webpage/oracle-l