Locate page
Column
Comparison
Values
Meet all conditions
Meet any conditions
Clear
Delete
OK
Cancel
Column
Use this field to specify one catalog column for each of the five Column fields to be used in the filter. The selected columns can even be the same with different values to filter for. But, you are not limited to these five columns because of the additional changes you can make using the Advanced page of the Locate notebook.
Comparison
Use this field to specify an SQL operator to help define the filter. Click on the arrow to display all the SQL operator choices. See SQL operators - in the SQL Reference for more information on the choices.
Values
Use this field to specify the value or values to use in the comparison. The filter is case sensitive. Multiple values must be separated by a comma, with each set delimited with a set of single quotes. Multiple values are generally used in an IN or NOT IN statement. In a LIKE comparison, you can use the % wildcard character to match 0 or more characters; or, you can use the underscore (_) wildcard character to match exactly one character. For example:
Meet all conditions
Click this radio button to implicitly add an AND between the search criteria.
Meet any conditions
Click this radio button to add an OR between the search criteria.
Advanced page
Customize the where clause
Reset
Delete
OK
Cancel
Customize the where clause
Use this field to derive your own WHERE clause, or add more predicate columns to the existing clause.
Reset
If this button is available, you have made changes to the WHERE clause that was generated from the Locate page of the Filter notebook, and the generated clause will not be used in the object filter. The changes you make on the Advanced page become your new WHERE clause. Select the Reset button to revert back to the generated WHERE clause from the Locate page of the Filter notebook instead of using the changes from the Advanced page.