Located on the Personal category tab in Search Builder this Condition allows you to search for people by their Middle Name, using all of part of the name.
TouchPoint has a field for Former Name that is used for a maiden name or a former name for someone that has remarried. However, sometimes people put their former name as their middle name, so keep that in mind when using this search Condition.
The search will look at the entire name,
so be careful when using <= or <= and a letter.
If you want one group whose names start with
through names that start with
The system will consider all the letters in the name.
So, when using
Equals N, for example, you will literally get only those
whose middle name is N, not Nancy or Ned.
You could, however, use
After or Same
and the letter
N and return those whose middle name begins with an N
or any other subsequent letter of the alphabet.
If you also add
Before or Same and the letter
P, you would get those who names
begin with N or O, and anyone whose names was exactly P.
But you would not get those whose middle name is Patricia or Patrick.