>Can anyone tell me whether SELECT - SQL respects SET DELETED ON/OFF? I used to know this.
>
>thank you

Yes, it respects it in all reasonable situations. The only exception if you run SELECT * From Table INTO Cursor, and even this case can be remedied by NOFILTER.