A-Z Display with MySQL

[SJH]

Hi all,

Is it at all possible to select records from a MySQL table which begin with a certain letter of the alphabet (or numerical), so I can make a dynamic A-Z display page?

Thanks in advance.

-Sam

[weirdbeardmt]

SELECT field FROM table WHERE field LIKE 'a%' ORDER BY field