[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Seach for more that one value in one SQL database column

Posted on 2014-07-30
1
Medium Priority
?
180 Views
Last Modified: 2014-07-30
I need to search a SQL server database table search for more than one value in a specific column....Example

SELECT tblEmployees where ZipCode = ('99201' and or '99202' and or '99202').......

Return all records who have a zip code of either 99201, 99202 and or 99202

Im not sure what the syntax would be.

Any help will be appreciated
0
Comment
Question by:Mike_Stevens
1 Comment
 
LVL 4

Accepted Solution

by:
Mark Olsen earned 2000 total points
ID: 40229609
Try the "IN" clause:

SELECT tblEmployees where ZipCode IN ('99201', '99202', '99202');

Open in new window

0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

590 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question