The Transact-SQL outer join operators *= and =* are supported in Sybase IQ, in addition to the SQL/92 join syntax using a table expression in the FROM clause.
Modulo The % operator can be used in Sybase IQ only if the PERCENT_AS_COMMENT option is set to OFF. The default value is OFF for new databases.
String concatenation When using the + concatenation operator in Sybase IQ, you should ensure the operands are explicitly set to strings rather than relying on implicit data conversion. For example, the following query returns the integer value 579,
SELECT 123 + 456
whereas the following query returns the character string 123456:
SELECT '123' + '456'
You can use the CAST or CONVERT function to explicitly convert data types.
When used with BINARY or VARBINARY data types, the + operator
is concatenation, not addition.
The || concatenation operator is not supported by Adaptive Server Enterprise.
