10 >= 9
Interpreted as "True".Relational Operations
This manual is in pilot operation.
|
Determines the match or mismatch, as well as the greater or lesser relationship of strings, numbers, and boolean values.
There are six types of comparison operators:
| Operator | Meaning |
|---|---|
= |
Left value is equal to the right value |
<> |
Left value is not equal to the right value |
>= |
Left value is greater than or equal to the right value |
< = |
Left value is less than or equal to the right value |
> |
Left value is greater than the right value |
< |
Left value is less than the right value |
-
If both sides are numeric or can be converted to numbers, they are compared as numbers.
-
Otherwise, both sides are converted to strings before comparison.
-
In string comparisons for greater or lesser (>=, < =, >, <), differences between uppercase and lowercase letters are ignored.
-
In string equality comparisons (=, <>), uppercase and lowercase letters are distinguished.