The condition type determines how Query Manager compares the values of the first expression to the second expression.


Some of the available condition types are:

• between

• equal to

• greater than

• in list

• in tree

• is null

• less than

• like


Query Manager also offers a not option that reverses the effect of each condition type. For example, not equal to returns all rows that equal to would not return.


In this topic, you will review query condition types.

Table of Contents