Common SQL Operators

The following are common SQL operators used in SQL statements.

Arithmetic Operators

Comparison Operators

Boolean or Logical Operators

Text Operators

Addressing Null Values

To search for or screen out NULL values requires the following syntax:

List Operators

Note: You cannot use the IN operator with Multi-Selection, Multi-Group, or Multi-User fields. For examples of operators that you can use, refer to the Using SBM–Processed SQL for Multi-Selection, Multi-Group, and Multi-User Fields.

Related Topics

About Pass-Through SQL

About SBM–Processed SQL