Erik,

------ huge snip
>
>I occasionally use a filter on indexes, but didn't think that it was allowed on primary indexes. Apparently so, but this leaves me pretty confused as to the definition of a primary key in the first place. I mean, I thought that an neforced unique key was just that... an enforced unique key. Can anyone clear this up for me?
>
>Erik
____ end snip

I guess its a bit like driving a car. You *could* drive on the other side of the road if you wanted to, even though you know you shouldn't.

I see Primary/Candidate indexes in rahter the same way - there are things you *CAN* do, but it doesn't mean you should do them.

regards,
Jim N