Best Practice for Zip Code Criteria

Brandi Sellers $organization over 9 years ago

I'm trying to set up a few lists for my team to be able to pull donors in a certain zip code and am struggling with the appropriate way to truly include everyone in those zip codes. We store both the standard five and five plus four zips in our instance of Tessitura and when I choose the criteria of Like with the 5 digit zip code it seems to skip anyone with the plus four. When I add the wild card indicator to the end of the 5 digits I'm looking for it includes anyone with those five digits in a row. Any advice?

Parents

Former Member $organization over 9 years ago

Hi Brandi, Postal Code Like xxxxx% seems to be pulling both types. Not sure why that is not the case with your settings. Ahmet Unal, IS Manager UMSL - Touhill PAC
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Brandi Sellers $organization over 9 years ago in reply to Former Member

Thanks for your response! I think the challenge with that as a value is that if the last four digits combined with the end of the zip result in the same value, it's pulling them as well. I basically am looking for people that have the exact same first five digits and I don't care what the last four are. I'm guessing I'll be going to SQL for this one.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Reply

Brandi Sellers $organization over 9 years ago in reply to Former Member

Thanks for your response! I think the challenge with that as a value is that if the last four digits combined with the end of the zip result in the same value, it's pulling them as well. I basically am looking for people that have the exact same first five digits and I don't care what the last four are. I'm guessing I'll be going to SQL for this one.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Children

Former Member $organization over 9 years ago in reply to Brandi Sellers

What I gave earlier should give a list with zip codes that start with "xxxxx" and does not care what comes after them. I thought that was what you needed. No?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Gawain Lavers $organization over 9 years ago in reply to Brandi Sellers

Hi Brandi, Can you post the query your list is creating? I.e. click on "manual query" and copy and paste the code? Thanks, Gawain
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Brandi Sellers $organization over 9 years ago in reply to Former Member

You're correct, that does seem to be working; however, I'm unable to find the inactive address option to include in the criteria set. Any hints?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Former Member $organization over 9 years ago in reply to Brandi Sellers

You may want to look at the fields under "Address Information" folder, especially "Address Exists" and "Primary Address Flag". Hope this helps.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel