>>No they wouldn't. The local SET DELETE setting has no effect on the SPT query. Do you have "Deleted=Yes;" in the ODBC connection string?
>
>Thanks, that did the trick.

You're welcome.

BTW, it true for all SET settings. They have to be set for SPT separately from the local settings.