>>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.
--sb--