Comparison operator: IN The IN operator tests a row or scalar value to see if it occurs in a set of values. For example, the expression: column IN (1,3,5,7,9) evaluates to True if and only if the value of column is 1, 3, 5, 7, or 9.