Filtering Data
Checking for Matches
Checking for Nonmatches
Checking for a Range of Values
Checking for No Value
Using the AND Operator
Using the OR Operator
AND and OR Operators
Using the IN Operator
Using the NOT Operator
4
Using the LIKE Operator
The 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
...