troubleshooting Question

MS SQL Query + multiple like '%%'

Avatar of dkilby
dkilbyFlag for Canada asked on
Microsoft SQL ServerMicrosoft SQL Server 2008SQL
5 Comments1 Solution2913 ViewsLast Modified:
i want to create a stored procedure that pulls a list from a table.

currently I am searching a comments field for keywords, using a like statement for each keyword, but I would like to pull the list of keywords from another table so if the keywords change i dont have to change the query.  Is this possible?

example of what i am currently doing.

select * from tblCustomerInfo
where comments like '%Test%' or comments like '%One%' or comments like '%Two%'
ASKER CERTIFIED SOLUTION
Harish Varghese
Project Leader

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer 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 1 Answer 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