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

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.
prophytAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
wdosanjosConnect With a Mentor Commented:
Do you mean something like this?

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

0
 
prophytAuthor Commented:
I know it was easy... thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.