I have a form where users can click on the colors check-boxes. These values go to query string like.
This gives values like ColorC=Red, Black, Blue
(1-20 color selections)
My question is that how to search the database by SQL statement. The following will not work in this case. I am using VBscript and MS SQL database.
SQL = "Select * from Products where DESCRIPTION LIKE '%" & ColorC & "%'"
The number of colors are not fixed, there could be 1, 2, 3, 5, 6 colors as selected by a user. And it has LIKE as it finds colors in product description. How does IN work in this case.