While working with a QueryPlus user on a mailing label list, we noticed some shortcomings in the Customer Name fields. This led to some modifications and new fields:

In AFW…

Customer Name (Firm or Full Name) now includes the middle name if it exists: Public, John Q

Customer Name (Firm or Full Name) for Mailing reverses the order: John Q Public

In AMS 360, things are a little more complex:

Customer Name (Firm or Full Name) is the field provided by the database, and is left unchanged. This field returns Last Name First Name Middle Name with no punctuation or special characters.

Customer Name w/Sp Char returns Last Name, First Name with punctuation and special characters.

Customer Name w/Sp Char and Middle Name returns Last Name, First Name Middle Name with punctuation and special characters.

Customer Name for Mailing w/Sp Char and Middle Name returns First Name Middle Name Last Name with punctuation and special characters.

These fields cover all of the ways to show Customer Name that we have thought of. Of course, if you need Customer Name in a different format, just let us know.