How could a CiviCRM database have 2 Marylands with 2 different
state_province_codes but both be identified with the same
1019 = Maryland 3497 = Maryland 1228 = United States
I only was alerted to this when my newly inherited client created a Smart Group to display all records with
postal_code between 20601 and 21930.
Is my CiviCRM instance corrupt or has a bad import caused this? Can I manually adjust the offending records without cascading problems? How would you suggest a fix for this?