I saw something, but I'm not sure what you were trying to do and also I haven't much experience myself.
BTW, I'm thinking which way would be better performance wise - my or Sergey's? Do you have a lot of members with that criteria? Can you run some tests?
>Thanks Naomi. I was close but didn't know how to name the derived table. ( I had it inside the ())
>Did you see my followup on the .NET post this AM?
>
>- Don
If it's not broken, fix it until it is.
My Blog