By default FileMaker searches for matches at the beginning of a word, not within the entire word; e.g. searching just for “A” gives you Antonia as well Marie-Antoinette (because FM regards the hyphen as word separator), but not Sabine or Carla.
When you are in Find mode, try using the Operators popup in the Toolbar; it offers a wide range of search operators and placeholders.
To find only names where the first (or only) name starts with an “A”, type "==A*" (without quotes) as search term.
I'm not sure what is going on here; a search using an A alone should find only entries with words beginning with A (note: this will include second words beginning with A). To find any word containing an A your search would have to include wild characters, ie. *A*. So what gives, I wonder? I don't suppose you have the field language set to something other than English?
Would <B suffice?
You want entries/phrases NOT starting with B - Z, yes?
What about numbers? What about lower case?
-- sent from my iPhone4 --
Thank you erolst, the "==A*" did exactly what I was looking to do.
Thank you so much for your help.
I am using it to build a navigation similar to how Outlook has buttons for Contacts starting with A or B, etc.
Just could not figure out the search term, but now erolst has show me I think I have solved my problem.
Another method I have seen is to have another field set to be a calc (or an auto-enter calc) set to =
Left( <YourFieldHere> ; 1 )
This makes an index field that you can search on or make relationships to a global match field and have A-Z buttons set to add or delete that letter from the global match field.
Can't take credit for it. Got it from Michael Rocharde's iBook "FileMaker and Me" - which I highly recommend!