Is there any combination of Operators and wildcards that would allow for a simple list to select constituents from multiple zip codes? I know an extraction can do this with one zip per keycode, but it would be great to be able to just do it in a list.
Thanks, Adam
You could certainly do it with a manual edit. Would an example like this work for you?select a.customer_nofrom dbo.t_customer cjoin dbo.t_address aon c.primary_address_no = a.address_nowhere left(a.postal_code,5) in ('63116', '63108')and c.inactive = 1
That's pretty cool. Thanks, I've never done Manual Edit before. Great help!