Multiple zips in extractions

Joe Hsu $organization over 11 years ago

could anyone provide how to edit codes to include multiple zip codes in a list manager (that also can be used in extractions?) And should I use = or Like?

Parents

Matthew Hoyt $organization over 11 years ago

Hi Joe,

Here's an example of how to get more than one zip code via a manual edit. Does this help?

select distinct customer_no
from dbo.VS_ADDRESS where LEFT(postal_code,5) in ('63124','63116') and primary_ind = 'Y'

Matt
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Reply

Matthew Hoyt $organization over 11 years ago

Hi Joe,

Here's an example of how to get more than one zip code via a manual edit. Does this help?

select distinct customer_no
from dbo.VS_ADDRESS where LEFT(postal_code,5) in ('63124','63116') and primary_ind = 'Y'

Matt
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Children

No Data