Thanks guys. Seems it's actually a problem with an escaltion using Application-Delete-Entry which is deleting records it shouldn't be, I'll investigate this seperately.
As for the 0=1 qualification, I understood that this only performs a full table scan on Oracle for certain versions of Oracle. I'll go through ours and get rid anyway. Cheers _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
