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

Try following my rule: NEVER ASSUME ANYTHING - if you don't want deleted records then say WHERE NOT DELETED(). Unless you specifically need to base the selection on the deleted setting!