is this expected behavior for a search?

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.

Hi Chris,

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:

Davis
Curt

... 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.

I knew a hippie couple with last name of Beach who named their kids ... Sandy and Rocky.  Absolute truth.