Not everyone with a c in their name, everyone who's name begins with a c.
There's two things going on:
1) Filemaker finds the string entered as a initial string followed by a wildcard. Every search terms has an asterisk at the end. Curt Curtis is Curt* curtis*.
2) The search returns if of the items match.
Curt Curtis is redundant as Curt will find Curtis. Dog Cat will find records like Dogbert and Catelyn.
To add a bit more ... during a search, FileMaker treats each word in a line as a separate search and each LINE as a separate search as well. So if you have text field with:
... and you search for Curt, it will find that record even though 'Curt' is not EQUAL to 'Davis¶Curt' nor does it START with Curt. And it would be found searching only for 'c' as well because that second line is treated as separate record. So in your example, searching for 'c' will find all WORDS THAT BEGIN WITH 'c', which is same as entering c*. If you DID want all words containing 'c' then it would be *c*.
Using == was not good example so I changed it and added to the example.
Thank You for the explanation guys. I feel much better know I know why it is happening. Who names their kid Curt Curtis anyway? Makes things dificult.
I knew a hippie couple with last name of Beach who named their kids ... Sandy and Rocky. Absolute truth.