To add to what Edward has suggested, you could do a SELECT * FROM MyTable WHERE NOT Deleted()

HTH

>Does anybody know the way to select only non-deleted records from the table in the case of SET DELETED ON is impossible?