|
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 sensitivityAll 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).