I am in the process of cleaning up our database. We've had GM for many years and recently upgraded to the SQL version.
I am wondering how others handle the acronyms for contacts, ie: Jack Spratt, Esquire or Joe Schmo, CPM. As it is currently entered, the "esquire" or "cpm" are considered the last name and not an acronym.
I am looking for suggestions on how else to handle this nomenclature.
Thanks.
I am wondering how others handle the acronyms for contacts, ie: Jack Spratt, Esquire or Joe Schmo, CPM. As it is currently entered, the "esquire" or "cpm" are considered the last name and not an acronym.
I am looking for suggestions on how else to handle this nomenclature.
Thanks.