Sybase Adaptive Server Anywhere - Operators

Chapter 6 SQL Language Elements
225
Operators
This section describes arithmetic, string, and bit-wise operators. For
information on comparison operators, see the section "Search conditions" on
page 239.
The normal precedence of operations applies. Expressions in parentheses are
evaluated first, then multiplication and division before addition and
subtraction. String concatenation happens after addition and subtraction.
Comparison operators
The syntax for comparison conditions is as follows:
... expression compare expression
where compare is a comparison operator. The following comparison
operators are available:
operator description
=
Equal to
>
Greater than
<
Less than
>=
Greater than or equal to
<=
Less than or equal to
!=
Not equal to
<>
Not equal to
!>
Not greater than
!<
Not less than
Case sensitivity
All string comparisons are case insensitive unless the database was
created as case sensitive.
♦ Trailing blanks Any trailing blanks in character data are ignored for
comparison purposes by Adaptive Server Enterprise. The behavior of
Adaptive Server Anywhere when comparing strings is controlled the
–b
command-line switch that is set when creating the database.
Compatibility