Use the Find window to find appropriate values for a search condition. You can look for values that include a specific character string, or you can display all the values in the column.
To search for a specific character string:
Specify the character string in the Search string field.
The % character is a wildcard character. For example, specifying A% searches for values that begin with the character A. Specifying %1 searches for values that end with the character 1. The specification A%1 searches for values that begin with the character A and end with the character 1.
Select a value from the Search limit list to control the number of values that are returned for the search.
If you want to search for the characters in uppercase or lowercase, exactly as you entered them in the Search string field, select the Case sensitive check box.
Click Search. The column specified in the Columns list on the Conditions page is searched for the value specified in the Search string field. The results of the search are displayed in the Available values list, up to a maximum number of rows as specified by the Search limit value.
Select one or more values from the list, and click OK. The selected values are added to the Values list in the Condition page.
Click OK to close the window.
To display all the values in the column, clear the Search string field, then click Search.