Alphabetical Glossary List

[johnyfav]

On my website about widgets I have a glossary. At first it was just to explain some key points but now it has turned in to a comprehensive resource of terms within my industry.

However it is now a large list, very large.

What I wanted to do is have a glossary front page then each letter in the alphabet have the corresponding words on the page, eg w would have widgets/widget x/widget y/......

But how would be the best way to do this?

All the data is currently in a sql database. Also would like to have a page for items that start with a number.

I have looked on goole however the search is so screwed up I can't find anything remotely of interest.

[Easy_Coder]

have you attempted something like this?

select distinct left(glossary_item_name,1) from tblGlossary