Export the query to Excel and remove the +4:

  1. In Excel, highlight the column with the ZIP codes.  For example, if the ZIP codes are in column H, click the H to highlight the column.
  2. Select Data, Text to Columns... from the menu bar. The Convert Text to Columns Wizard appears.
  3. In Step 1 of 3, ensure Delimited is selected and click Next
  4. In Step 2 of 3, unmark Tab and select Other. In the text box next to other, enter a dash (-).  Note: enter the actual - not the word dash. Click Next.
  5. In Step 3 of 3, make no changes and click Finish.
  6. The +4 are placed in a different column. For example, if the ZIP codes were originally in column H, the 5 digit ZIP remains in H. The +4 is placed in the I. Delete the column with the +4.
  7. Sort the spreadsheet by ZIP and save in CSV format. Use this file to merge in Word.

Use one of the following filters in the query:
  1. Zip code does not contain - 
  2. Zip code = the specific zip code
  3. Zip code one of specific zip codes
Note: When in query, in criteria when searching for the zip codes with the +4, you can use the wild card character * after the zip code to bring up the zip codes with the +4.
Example: To search for those with a Zip Code 12345-6789, you can search in Criteria Zip Code equals 12345*.

This will only work with the operator of "equal", it will not work with the operator "one of". So if we need to do multiple zip codes with the +4, we'll want to do multiple Preferred Zip "equals" fields all grouped with an "OR" in the query.  


Sort by ZIP code in Crystal Reports.