T-SQL Logical Operators

Operator	Meaning
ALL	TRUE if all of a set of comparisons are TRUE.
AND	TRUE if both expressions are TRUE.
ANY	TRUE if any one of a set of comparisons are TRUE.
BETWEEN	TRUE if the operand is within the range of comparisons.
EXISTS	TRUE if a subquery contains any rows.
IN	TRUE if the operand is equal to one of a list of expressions.
LIKE	TRUE if the operand matches a pattern.
NOT	Reverses the value of any other operator.
OR	TRUE if either expression is TRUE.
SOME	TRUE if some of a set of comparisons are TRUE.