Yes, you are right. But i read documentation long ago that filtered indexes are not optimized, so i try not to use a FOR clause with permanent indexes.

Thanks again,

Juan Carlos Jaramillo

>Juan;
>
>Do you mean that if you have a person with Social Security # 111-11-1111, and then delete him, that you can't later add him, or another person with an SS# of 111-11-1111? If that's what your problem is, you can put a filter on your candidate for for NOT DELETED(). Then when a record is deleted, it is removed from the index as well.
>