Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » SQL Language Elements » Operators

Operators Next Page

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.

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.

For more information about case sensitivity for string comparisons, see Initialization utility (dbinit).

Trailing blanks     The behavior of SQL Anywhere when comparing strings is controlled by the -b option that is set when creating the database.

For more information about blank padding, see Initialization utility (dbinit).