>No, there wasn't a misunderstanding. I merely qualified your flat statement that one shouldn't have an index on deleted() and gave the exception. That's all. Althought I did leave out the additional qualifer that it depends also on whether one uses SET DELETED ON or OFF.
Oh, sorry. My misunderstanding, then.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)