Saved Search to Display Customers whose Address Falls Within a Zip Code Range.

There can be several customer addresses with different zip codes. To create a saved search showing customers whose addresses fall within a range of zip code (i.e., 80000 to 90000), perform the following: 

1.      Navigate to Transactions > Management > Saved Searches > New.

2.      Click Customer.

3.      Under Criteria tab and Standard sub tab, add Formula (Numeric) field then set the following:

Formula = case when to_number({zipcode}) between 80000 and 90000 then 1 else 0 end

Formula (Numeric) = equal to

Value = 1

4.      Under Results tab and Columns sub tab, set the following:

1.      Name

2.      Zip Code

5.      Enter name for the search.

6.      Click Save.

Notice that the search displays customers whose addresses fall under zip code range 80000 to 90000.