Comparison operators

The syntax for comparison is as follows:

expression comparison-operator expression

where comparison-operator is one of the following:

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

By default, SQL Anywhere databases are created as case insensitive. Comparisons are carried out with the same attention to case as the database they are operating on. You can control the case sensitivity of SQL Anywhere databases with the -c option when you create the database.

Case sensitivity is set at database creation.

Note

All string comparisons are case insensitive unless the database was created as case sensitive.