Sergey, the following code hangs on my computer at around 50%. I also tried on my co-workers computer. Any suggestions? Also, will this code still return all the records which have expired in a month but if a record has 2 the one with the max(expdate)?

select * from rcbfile a ;
where expdate between ctod('09/01/2002') and ctod('09/30/2002') ;
and expdate ;
IN( select max(expdate) ;
from rcbfile b ;
where b.id = a.id)

Thanks,
Sunshine