[Resolved] WHERE statement -- quick question

[zzz]

Trying to put together a quick directory, need to be able to retreive results by clicking on a a letter of an alphabet. Sudden block:

how do I query for results starting with a particular letter?

[devinemke]

SELECT * FROM table WHERE field LIKE 'a%'
SELECT * FROM table WHERE field LIKE 'b%'
SELECT * FROM table WHERE field LIKE 'c%'
etc...

[zzz]

Gee I love this board!

I was putting %% on both sides... dah.