Join Operators

The Transact-SQL™ outer join operators *= and =* are supported in Sybase IQ, in addition to the ISO/ANSI SQL join syntax using a table expression in the FROM clause.

Compatibility

Modulo—The default value is OFF for new databases.
String concatenation—When you are using the + concatenation operator in Sybase IQ, 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.

Note: When used with BINARY or VARBINARY data types, the + operator is concatenation, not addition.

The || concatenation operator is not supported by Adaptive Server Enterprise.