IN operator form to check if value matches one of the listed

IN operator allows to check if expression value that is specified on the right side matches one of the values described on the left side. If at least one match is found, the result of the operator is TRUE, else it is FALSE. You can inverse operator action by using NOT. Value Comparison Rules are used to compare the values.

Example:

SELECT
   Catalog.Nomenclature.Description

WHERE
   Catalog.Nomenclature.Parent.Description
   IN ("Home Appliances", "Office Equipment")