Main expression editor
In the expression editor, you can specify a filter that uses the Between, Comparison, In, Like, or Null predicates.
To specify an expression:
- Choose the type of filter by choosing a predicate from the list.
- Fill in the information required by the Expression Editor fields that appear.
- Click the Add button to add the filter to the query you are building. This clears the expression editor so that you can add another filter if required.
The contents of the expression editor vary according to which predicate you have selected. The following predicates are available:
- Between. Allows you to specify that the value in a column should lay within a certain range.
- Comparison. Allows you to specify that the value in a column should be equal to, or greater than or less than, a certain value.
- In. Allows you to specify that the value in a column should match one of a list of values.
- Like. Allows you to specify that the value in a column should contain, start with, end with, or match a certain value.
- Null. Allows you to specify that a column should be null or should not be null.