Mike,

If you use any SQL commands on the table after you have deleted, but not packed a table, remember that the SQL SELECT statement ignores the SET DELETED setting. You therefore should index the table on DELETED(), and include NOT DELETED('tablealias') in the WHERE clause of any SQL command.

David