SQL Server IN statement with wildcard [duplicate]

Question

Possible Duplicate:
Is there a combination of “LIKE” and “IN” in SQL?

The first where clause below runs fine for me but it does not pick up contacts that might have 45211-1234 or 45213-4321

SELECT * FROM contacts
WHERE zipcode IN ('45211','45213')

I thought I could change the where clause to the below to fix, but it fails.

SELECT * FROM contacts
WHERE zipcode IN ('45211%','45213%')

How might I change this so it brings back anything that has proper zip + dash + any zip4? For example, 45211-1234 or 45213-4321.

Note I have whole bunch of zipcodes to enter, not just these two.

Sam Anwar · Accepted Answer · 2012-08-30 18:02:27Z

3

How about this:

SELECT * FROM contacts
WHERE Left(zipcode,5) IN ('45211','45213')

answered Aug 30, 2012 at 18:02

Sam Anwar

6895 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Works great and simple for me to understand. Thanks!