WHERE Clause Operators
Filtering Data
Checking for Matches
Checking for Nonmatches
Checking for a Range of Values
Checking for NULL
Using the AND Operator
Using the OR Operator
Combining AND and OR
Using the IN Operator
Using the NOT Operator
4
Using the LIKE Operator
WHERE Clause Operators
list of operators:
Operator
Description
=
Equality
<>
Non-equality
!=
Non-equality
<
Less than
<=
Less than
or
equal to
>
Greate than
>=
Greate than
or
equal to
BETWEEN
Between
two specified
values
IS
NULL
Is
a
NULL
value
...