I want to query the rows of SQL column for whether it contains any one of multiple values.
For instance, return rows of a table where its column A contains any of the following words:
('cow','farmer','milk').
Easy enough when you know what the words are, but I want to write a sproc where I can feed in any array of strings and if the column A for a certain row contains any of them, it would return the row.
I would want to be able to feed in:
('cow','farmer','milk')
or
('cow','farmer','steak','yikes')
or
('cow','farmer','three', 'pigs', 'wolf')
It must be relatively straightforward, but I cannot for the life of me figure it out. I'm on SQL Server 2008