The procedure for entering comparison values differs depending on what kind of value you are entering:

• If you are comparing one field to another, select the second record field.

• If you are comparing the rows to a constant value, enter the constant.

Some of the comparison values are:

• Field

• Expression

• Constant

• Prompt

• Subquery

• In List

• Current Date

• Tree Option

• Effective Seq (effective sequence)

In this topic, you will review query comparison values.

Table of Contents