I have a list of contacts with zip codes that are both 5 digit and 5 digit + 4.
For example: 12345 and 12345-5555
This is shown in the attached file under the table "Master".
I have another table called "Zip Info" which ties in certain information based on zip code, such as Color and Area, however, this uses zips that are 5 digits only.
How would I write query so that the Zip code is truncated to the first 5 digits so that it can match up to the proper record in the "Zip Info" table.
A sample of the final desired version is shown in the table "FINAL SAMPLE".