Middle Name

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.

Tip

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.

Using Ranges

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 A through names that start with M, use Before N.

Another Reminder

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.