Title
is this expected behavior for a search?
Post
In our solution customer names are stored in a field called full name. I recently encountered a customer who's name was Curt Curtis. When preforming a search to see if he had purchased anything from us before I entered Find mode and put Curt Curtis into the full name field. I was surprised when I received 35 results! Every single person with Curtis as part of their name was returned as a result. Under this theory if I search for c c c c c, every person who has a c in their name would be returned?
While I understand that placing the name in quotations will return an exact match, I don't really understand the reason for the initial result. Any insight would be appreciated.
Chris
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.