Creating Sections Pages

a-f g-l m-r s-z

[ukgimp]

I have a set of words that range from a-z, but some may not be present. Is there an obvious way to extract all words that are in each region of the alphabet. I can seemto get my head around this one.

Cheers

[txbakers]

select distinct ( left (fieldname, 1) ) from table

might work