List all entries that start with 'A'

[globay]

How do I list all entries from a database, that start with a special letter?

[jpjones]

Try:

SELECT * from TblName where FieldName Like "A%";

You might have to change the "A%" to "A*" depending on your SQL engine.

Also see:
http://www.webmasterworld.com/forum47/381.htm [webmasterworld.com] for further info relating to your question.

HTH,
JP

[globay]

Thanks a lot,

works perfectly!