AnsweredAssumed Answered

Efficient Way For Finding Names

Question asked by dhillock on Jan 27, 2012
Latest reply on Jan 27, 2012 by davidanders


Efficient Way For Finding Names


I have three fields, called NameFirst, NameLast, and WasFound.

I have a list of 12 names and if someone from the list is found, I want to set WasFound to 1.

Given that people sometimes enter their names in revers order (Mary Smith, versus Smith Mary, in upper case, lower case, or mixed case, what is the most efficient way to see if I have any of these people in by table? All suggestions appreciated.