>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.