Comparison Operators
Comparison operators compare two expressions of the same data type. The result of the comparison is a Boolean value. The following table summarizes these operators:
| Operator | Meaning |
|---|---|
|
= |
Equal |
|
!= |
Not equal |
|
<> |
Not equal |
|
< |
Less than |
|
<= |
Less than or equal to |
|
> |
Greater than |
|
>= |
Greater than or equal to |
You can precede any of the comparison operators with the word Not, for example:
-
Not=
-
Not<
-
Not>=
Expressions formed with comparison operators form logical terms that can be combined using Boolean operators.
String comparisons are case-sensitive. You can use the Upper or Lower built-in functions to do a case-insensitive comparison.