Perform an SQL Where Clause Search

Use this procedure to find specific information from a table by creating additional criteria. Before proceeding, see SQL Where Clause Search.

The SQL Where Clause search is only available for users who are members of the SYSADMIN group.

For more information on search types and options, see Search Overview.

To search using the SQL Where Clause search, complete the following steps:

1. Beside the Search field, click . A search dialog box displays.

2. From the Display Type drop-down list, select SQL Where Clause. The Where Clause entry field and another field (which displays below the Display Search Text check box) displays, containing the SQL statement that you want to use for the search.

   If the Display Search Text check box is not selected, the field below the Where Clause field is initially empty. Clicking Search displays the search results in a grid, replacing the empty field.

3. In the Where Clause field, enter or modify the SQL statement. For more information, see SQL Where Clause Search Operators.

4. Verify that the Display Search Text check box is selected to display the SQL Where Clause used in the search. The displayed text is the readable, color-coded, indented version of the current SQL Where Clause search.

   The Display Search Text check box is not selected the next time you click Search.

5. Verify that the Show Result List check box is selected to display the grid that contains the results of the search when you click Search.

6. Click Search. A list of all records matching your search criteria displays.

7. If an error message occurs, correct the error in the entered SQL statement and then click Search again.

8. Click Select All to display all records, or highlight only those records you wish to display by pressing the CTRL and SHIFT keys at the same time and then clicking Select. The first record that matches your criteria appears.

What do you want to do?

Save a search

Use a saved search

Learn more about...