Bruce,

Glad to see that solved it!

But was it needed because you were running with SET DELETED ON or is it just a "thing" with the optimizer???

Inquiring minds *need* to know!

Cheers,
Jim N

>>Hi Bruce!
>>
>>Just add index on Deleted() and enjoy ;)))
>>
>That's it! Thanks for help.