Dynamic Like Statement in SQL
- by Peter McElhinney
Hey there!
I've been racking my brain on how to do this for a while, and i know that some genius on this site will have the answer. Basically i'm trying to do this:
SELECT column
FROM table
WHERE [table][column] LIKE string1 OR [table][column] LIKE string2 OR [table][column] LIKE string3...
for a list of search strings stored in a column of a table. Obviously I can't do a like statement for each string by hand because i want the table to be dynamic.
Any suggestions would be great. :D
EDIT:
I'm using MSSQL :(