Comparison conditions in search conditions use a comparison operator.
The syntax for comparison conditions is as follows:
expression compare expression
where compare is a comparison operator. This table lists the comparison operators available in SAP Sybase IQ.
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 |
SELECT Surname, BirthDate FROM Employees WHERE Surname <= ALL (SELECT MIN(BirthDate) FROM Employees);
The subqueries that provide comparison values for quantified comparison predicates, as in the preceding example, might retrieve multiple rows but can only have one column.
Case-sensitive if the database was created as case respect (the default)
Case-insensitive if the database was created as case ignore
Trailing blanks—Any trailing blanks in character data are ignored for comparison purposes by Adaptive Server. The behavior of SAP Sybase IQ when comparing strings is controlled by the Ignore Trailing Blanks in String Comparisons database creation option.
Case sensitivity—By default, SAP Sybase IQ databases, like Adaptive Server 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 SAP Sybase IQ databases when creating the database.