is this expected behavior for a search?
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.