Fields: Product ID, Category (checkbox field so more than one category can be checked.)
I need to write a sql statement to find records by searching the Category field, which can have more than one item checked.
What I have below only works if there is a single category in the Category Field.
(Category = 'CAT001' )
How do I write the statement so it will find "CAT001" even if there other Categories checked for that field?