troubleshooting Question
MS SQL Query + multiple like '%%'
asked on
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%'
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%'
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.
Our community of experts have been thoroughly vetted for their expertise and industry experience.