Comparison CCL operators conducts a comparison of TRUE, FALSE, or NULL.
Comparison operators compare one expression to another. The result of such a comparison can be TRUE, FALSE, or NULL. Comparison operators use the following syntax:
expression1 comparison_operator expression2
where expression1 and expression2 are a pair of numeric, Boolean, String, or Timestamp expressions and comparison_operator is one of the operators described in the following table:
|
Operator |
Purpose |
|---|---|
|
= |
Equality, which can also be used in a multi-equality expression, such as A=B=C. |
|
!=, <> |
Inequality. |
|
>, < |
Greater-than and less-than . |
|
>=, <= |
Greater-than-or-equal-to and less-than-or-equal-to. |
When comparing numeric expressions, Sybase uses numeric precedence to determine whether the condition compares INTEGER or FLOAT values.