i have a table with a varchar(500) product description field.
a user can search on the product description by entering numerous keywords.
i'm trying to write a stored proc (don't want to have to use dynamic sql)
to select all products that have words product descriptions that match the keywords

in a normal, single parameter proc i would use something like
Code:
where productdescription like '%' + @blah + '%'
but with a variable number of possible parameters i can't do something like this inside a proc
Code:
where productdescription like '%blah%'
or productdescription like '%stuff%'
--etc etc etc
so how do i handling the fact thet i need to be able to do like comparisons for a variable number of arguments?