Is it possible to use the LIKE and IN in the WHERE clause?
I have a where clause that's like this:
WHERE (Customers.CompanyName = @Company) and
(ChangeLog LIKE '%' + @product + '%' + '%1%')
This is good when selecting one product, but we have several products and wanted to use IN but with LIKE at the same time.
Thanks for any possible help.
-Gonzalo