Relational operators
All relational operators compare the values of the operands and return True (-1) or False (0) as the result. All relational operators are binary.
Operator | Description |
---|---|
< | Less than. A numeric comparison is made if both operands can be interpreted numerically. The operation returns the logical value of the evaluation of the comparison. |
<= | Less than or equal. A numeric comparison is made if both operands can be interpreted numerically. The operation returns the logical value of the evaluation of the comparison. |
> | Greater than. A numeric comparison is made if both operands can be interpreted numerically. The operation returns the logical value of the evaluation of the comparison. |
>= | Greater than or equal. A numeric comparison is made if both operands can be interpreted numerically. The operation returns the logical value of the evaluation of the comparison. |
= | Equals. A numeric comparison is made if both operands can be interpreted numerically. The operation returns the logical value of the evaluation of the comparison. |
<> | Not equivalent to. A numeric comparison is made if both operands can be interpreted numerically. The operation returns the logical value of the evaluation of the comparison. |
precedes | Unlike the < operator no
attempt is made to make a numeric interpretation of the argument values
before the comparison. The operation returns true if the value to the
left of the operator has a text representation which, in string comparison,
comes before the text representation of the value on the right. Example: '1 ' precedes ' 2' returns FALSE ' 1' precedes ' 2' returns TRUE as the ASCII value of a space (' ') is of less value than the ASCII value of a number. Compare this to: '1 ' < ' 2' returns TRUE ' 1' < ' 2' returns TRUE |
follows | Unlike the > operator no
attempt is made to make a numeric interpretation of the argument values
before the comparison. The operation returns true if the value to the
left of the operator has a text representation which, in string comparison,
comes after the text representation of the value on the right. Example: ' 2' follows '1 ' returns FALSE ' 2' follows ' 1' returns TRUE as the ASCII value of a space (' ') is of less value than the ASCII value of a number. Compare this to: ' 2' > ' 1' returns TRUE ' 2' > '1 ' returns TRUE |