3
Operators

An operator manipulates individual data items and returns a result.

This chapter contains these sections:

• About SQL Operators
• Arithmetic Operators
• Concatenation Operator
• Set 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, please refer to Chapter 5, "Conditions".