Group by first letter ?

[Stressed]

What I am looking to do is lets say I have a list of links. So my data looks something like.

A Link Here
Not another Link
Nope its another link
Crapola links do exist
Boy this is a great link.

Now lets say I want to rotate the order of those links. One time I want it to go like N-Z then A-M. Then the next time I want like C-Zthen A-B. Anyone know of a way with a query that I could do this? Like some sort of a group by?

Andy

[barand]

Your basic query would be

SELECT linkname, LEFT(linkname,1) BETWEEN 'A' AND 'M' as sortkey
FROM mydatatable
ORDER BY sortkey , linkname

This gives
N-Z
A-M

Changing the sort to '... ORDER BY sortkey, linkname DESC' gives
Z-N
M-A

Changing the sort to '... ORDER BY sortkey DESC, linkname DESC' gives
M-A
Z-N

hth