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.