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.
BETWEEN value_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.

Value

value can be any value of the same data type as the column's data type.

Related concepts