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%'