Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4
I'm pulling a group of constituents in Extraction Manager and I want to identify only those that have SCF 100, 101, 104, 112, and 115-118 as part of the zip codes. I know how to identify solely constituents having each of those SCFs by picking "postal code" like "100%". But, how do I identify multiple SCFs and do it as part of a broader extraction (for example: in an extraction of 100 concert attendees, I want only the 25 in the specific SCFs). Does anyone know how to do this or know the manual edit query code?
Chuck Buchanan
Manager, Direct Marketing and List Management
92nd Street Y
1395 Lexington Ave | New York, NY 10128
(212) 415-5451 | http://www.92Y.org
Take this piece: AND e.postal_code like '100%'
and substitute with this:
AND LEFT(postal_code,3) in ('100','101','104','112')
~Dan
Hi Dan,
This was helpful and pulled the SCFs that I was looking for. However, since it will be part of an extraction - how can I flip that query to be "not like" and use it as a suppression to essentially suppress every zip code not starting with those SCFs?
Thank you for the help!
Please disregard, I figured out how to do this! Of course it was as easy as changing "in" to "not in".
In case anyone else is interested, here is the manual query (identifying all primary addresses not in those SCFs).
Select Distinct a.customer_no From t_customer a (NOLOCK) JOIN vs_address e (NOLOCK) ON a.customer_no = e.customer_no Where IsNull(a.inactive, 1) = 1 AND e.primary_ind in ('Y') AND LEFT(postal_code,3) not in ('100','101','104','112','115','116','117','118')
Simple, change it to:
AND LEFT(postal_code,3) NOT IN ('100','101','104','112')
and make that a suppression segment.