Operators

Operators are used in expressions to compare a column's value against another value.

Expressions can be composed with the operators from the following table:

Operator	Description
= == IS	Tests what is on each side of the operator for equality.
!= <> IS NOT	Tests what is on each side of the operator for inequality.
>
<
>=
<=
ISNULL IS NULL	Tests that the row does not contain a value in this column.
NOTNULL NOT NULL IS NOT NULL	Tests that the row contains a value in this column.
BETWEENvalue_1 and value_2	Requires two values, separated by the keyword and. The range includes the end values.
IN(value [,value ]* )	Requires a set of values, separated by commas, surrounded by parentheses.
value_1 LIKE value_2	Searches the left operand for the pattern specified by the right operand. For details about the LIKE operator, see LIKE Operator.