Operators

The table below lists the operator and expression syntax in message selectors (based on the SQL-92 SELECT statement syntax):

Element	Syntax and Specifications
Logical	In precedence order: NOT, AND, OR
Comparison	=, >, >=, <, <=, <> (not equal)
Arithmetic	In precedence order: Unary + or − Multiplication * or Division / Addition + or Subtraction −
Arithmetic range between two expressions	expr1 BETWEEN expr2 AND expr3 expr1 NOT BETWEEN expr4 AND expr5

An example of logical operator is usage is:

 x NOT = true 

An example of arithmetic operator usage is:

 y - 64 

An example of arithmetic range operator usage is:

 z NOT BETWEEN 19 AND 28