Home → TechDocs → Contacts → Removing the 9 Digit Postal Codes for Contacts
Keywords (words are separated by a “;”): zip; code; postal; digits; plus; four; 4; remove; fix;
This document will show you how to fix your database zip codes for contacts only, taking them from a nine digit postal code to a five digit code. You have two options for correcting the zip codes in your database the first option is your entire database at once.(See steps 1-5) The second option is to update just the contacts you have selected. (See step 6-11)
Part 1 - Update Zip Codes for the Entire Database
Part 2 - Update Postal Codes for Individual Contacts
**NOTE: These are advanced operations and there is not an “undo” feature for the steps listed. Please make sure you have a backup of your database before you begin these changes.**
Step 1: Login to your Database as the Administrator
Step 2: Go to the Data Doctor by going to File – Administration – Data Doctor
Step 3: Once in the Data Doctor go to the Surgery tab
Step 4: In the SQL Statement field type in exactly, “ update contact set zipcode = left(zipcode,5) “ as shown below.
Step 5: Click on the Execute button. You will now see the effected records in the Results field.
Step 1: Start by logging into your database as the Administrator.
Step 2: Find the contacts that you want updated. A group, a specific search or a filter whichever you do make sure that you have the contacts you want to have the postal codes changed for selected on the screen.
Step 3: Go to the Data Doctor by going to File – Administration – Data Doctor
Step 4: Once in the Data Doctor go to the Surgery tab
Step 5: In the SQL Statement field type in exactly, “ UPDATE CONTACT INNER JOIN selectedContact ON CONTACT.LinkID = selectedContact.ContactID SET CONTACT.ZipCode = Left([zipcode],5) “
Step 6: Click on Execute, you will now see the effected records in the Results field.