Ah! the grouping problems... always love them.

I also taught I knew a lot about SQL but there is always something new to learn lurking around the corner.

Wow! I am impressed!

So soon!

I'll start "digesting" what you submitted.

Would you be so kind in explaining your solution?

I knew it was possible to do this. It only took one guru...

Great example but bad performance compared to a dynamic sql.

Using your example with LIKE does a table scan which is very costly.

Using the IN directive do an INDEX SEEK if...

noeld, it's working great!

Thank you very much.

You are indeed a valued contributor!

cmore: great solution but I need something not in a sproc...

noeld: that's what I did to generate the rank but I am having a hard time using this in an...