AnsweredAssumed Answered

execute SQL from value list

Question asked by NancyAdelman on Sep 2, 2015
Latest reply on Sep 2, 2015 by erolst

Hello,

 

Table: Product

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.

 

SELECT

Product_ID

FROM

Product

WHERE

(Category = 'CAT001' )

 

How do I write the statement so it will find "CAT001" even if there other Categories checked for that field?

 

Thank you.

 

Nancy Adelman

Adelman Databases

www.adelmandatabases.com

nancy@adelmandatabases.com

Outcomes