>>Hi everybody,
>>
>>I'm trying to help someone and I found an interesting problem here
http://forums.asp.net/p/1324965/2642788.aspx#2642788>>
>>Suppose we have a Stored Procedure where we pass the list of keywords (comma-delimited list) and we want to have a result where the text may contain any of the passed keywords (in that list).
>>
>>Is it possible to write such a statement or we need to use dynamic query with OR for each keyword?
>>
>>Thanks in advance.
>
>You could use dynamic sql OR you could create a table function where you could SPLIT that parameter and the join the resulting table to that you want.
I don't understand how would you join for OR condition. Looks like OR requires dynamic SQL, I see no other way to construct the query.
If it's not broken, fix it until it is.
My Blog