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.