string compare in table field
I have a field in a database called categories with values separated by commas, example.
This field was saved into the table thourgh a list box selection element.
now in my application the user selects values from a list box and those values are compare to the database field categories. If one of those values selected in the search appears in the categories field that row is selected for display. example
In application user selects from list box:
so the records to return are:
13 15 16
currently my application is accepting one value from the list box and it works fine, i am using the '%like with wildcard%' option, but I need to pass and compare multiple values.