troubleshooting Question

Select SQL Query Multiple phrases using "like" parameter

Avatar of vb7guy
vb7guyFlag for United States of America asked on
Microsoft SQL ServerMicrosoft SQL Server 2005SQL
5 Comments2 Solutions942 ViewsLast Modified:
Can I combine two SQL phrase in a single where clause. Here is an example. it hasn't worked for me and I couldn't find any in the help file.  I may have more then two publicationID that I'm trying to pull, but I don't know the full name.

I want to able to use "like" and "in" in the same statement.

select PublicationID,publicationname  from dbo.tblPublication where publicationname in (like '%Asia Pac%',like '%Global Watch%')
Join our community to see this answer!
Unlock 2 Answers and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros