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
but with a variable number of possible parameters i can't do something like this inside a procCode:where productdescription like '%' + @blah + '%'
so how do i handling the fact thet i need to be able to do like comparisons for a variable number of arguments?Code:where productdescription like '%blah%' or productdescription like '%stuff%' --etc etc etc




Reply With Quote