Need some help here.
I was trying to make a Stored Procedure in MS SQL 2008 which will make use of comma delimited string as Parameter in my WHERE [COLUMN] LIKE [PARAMETER] condition.
Somehow, I was able to select rows of data from my DB table that matches the set of values I passed to the parameter however, Im not getting the ideal output from it.
Supposed I have a product 'BOLT & CAP ORANGE' and 'BOLT & CAP RED' in my PRODUCTS Table. Using C# as front end, if I typed "BOLT, ORANGE" in the search field I provided on my windows form, both products are being displayed. But what I need is that, whenever I type a string separated by comma in the search field, ONLY those products that has a "BOLT" and "ORANGE" words should be displayed, 'BOLT & CAP ORANGE' for instance.
Is this possible?