SQL Operators

These topics describe the arithmetic, string, and bitwise operators available in SAP Sybase IQ.

The normal precedence of operations applies. Expressions in parentheses are evaluated first; then multiplication and division before addition and subtraction. String concatenation occurs after addition and subtraction.

• Arithmetic Operators
  These arithmetic operators are available in SAP Sybase IQ.
• String Operators
  These string operators are available in SAP Sybase IQ.
• Bitwise Operators
  You can use these bitwise operators on all unscaled integer data types, in both SAP Sybase IQ and Adaptive Server.
• Join Operators
  The Transact-SQL™ outer join operators *= and =* are supported in SAP Sybase IQ, in addition to the ISO/ANSI SQL join syntax using a table expression in the FROM clause.
• Operator Precedence
  Follow this recommendation to make the order of operation explicit.