Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How do I query a listing of unique numbers against a column in a SQL database?

Posted on 2011-02-17
2
Medium Priority
?
247 Views
Last Modified: 2012-05-11
How do I query a listing of unique numbers against a column in a SQL database? For instance, I would like to find/return all matching records from comma delimited list (abc123, abc124, abc125, abc126, etc). I really don't want to search for them individually.
0
Comment
Question by:prophyt
2 Comments
 
LVL 23

Accepted Solution

by:
wdosanjos earned 2000 total points
ID: 34920398
Do you mean something like this?

select * from YourTable where YourColumn in ('abc123', 'abc124', 'abc125', 'abc126')

0
 

Author Comment

by:prophyt
ID: 34920466
I know it was easy... thanks.
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Screencast - Getting to Know the Pipeline

916 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