a character specific query

[Errol Kemp]

i am trying to create a query that when you open the query
it asks you what topic you want to search for and you can
enter the "b" and it will come up with all the topics that
start with "b". i run access2000.

 

[Ken Snell]

SELECT * FROM TableName
WHERE FieldName Like [What is the first letter of the words to be found?] &
"*";