This table describes the compatibility of expressions between Adaptive Server and SAP Sybase IQ.
This table is a guide only, and a marking of Both may not mean that the expression performs in an identical manner for all purposes under all circumstances. For detailed descriptions, see the Adaptive Server documentation and the SAP Sybase IQ documentation on the individual expression.
In this table, expr represents an expression, and op represents an operator.
Expression |
Supported By |
|---|---|
constant |
Both |
column name |
Both |
variable name |
Both |
function ( expr ) |
Both |
- expr |
Both |
expr op expr |
Both |
( expr ) |
Both |
( subquery ) |
Both |
if-expression |
SAP Sybase IQ only |