Have to give Frank credit for this!

There was a URL to MS discussing it. Did caution on large tables.

Maybe Frank still has the URL.

Use PUBS

Go

select rank=count(*), a1.au_lname, a1.au_fname

   from authors a1, authors a2

   where a1.au_lname + a1.au_fname >= a2.au_lname + a2.au_fname

   group by a1.au_lname, a1.au_fname

  order by 1

Cheers,

Crispin