Claude,

>with one to three expressions. Can this be done if so how. Would a SCAN loop be better (what are the performance hits). During testing I noticed deletion for tables with ref integrity rules seem to take a while.

Make sure that you have the RI related tabels already open in another workarea. This might speed up performance by a 100 - 300 % or more. This is because the RI opens and closes the table for each record. If youa already have opened the table in another workarea the opening process is much and much faster.

Walter,