ASA SQL Reference
SQL Language Elements
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 sensitivityAll 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.
For more information about blank padding, see Initialization utility options.
Case sensitivity By default, Adaptive Server Anywhere databases are created as case insensitive, while Adaptive Server Enterprise databases are created as case sensitive. Comparisons are carried out with the same attention to case as the database they are operating on. You can control the case sensitivity of Adaptive Server Anywhere databases with the -c command line switch when you create the database.
For more information about case sensitivity for string comparisons, see Initialization utility options.