An operator manipulates data items and returns a result. Syntactically, an operator appears before or after an operand or between two operands.

This chapter contains these sections:

• About SQL Operators

• Arithmetic Operators

• COLLATE Operator

• Concatenation Operator

• Hierarchical Query Operators

• Set Operators

• Multiset Operators

• User-Defined Operators

This chapter discusses nonlogical (non-Boolean) operators. These operators cannot by themselves serve as the condition of a WHERE or HAVING clause in queries or subqueries. For information on logical operators, which serve as conditions, refer to Conditions.