>
>Okay, thanks a lot. In the mean time I had been working on the SQL and received help from Dorin in this thread. You can check out his response and the newly developed SQL.

I think you'e missing my point. I looked at your CASE expression and don't understand why it has to be so complicated.

>
>Thanks a lot for all your help. Wishing you the best of luck for this years Personality award too.

Thank you.