AnsweredAssumed Answered

is this expected behavior for a search?

Question asked by c.wagner1 on Nov 4, 2011
Latest reply on Nov 4, 2011 by LaRetta_1

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

Outcomes