A WHERE clause is used to filter records and extracts only those records that fulfill a certain criterion. You can search using the WHERE clause if you know Structured Query Language (SQL).
To perform queries using the WHERE clause, you must be familiar with both SQL and the database. If you know SQL you can modify the WHERE clause to change your search parameters. Constructing SQL queries is something that is more commonly performed by system administrators and database administrators. The WHERE Clause window shows the SQL where clause for your current query. The Current Query field shows the current query whether you searched using the View/Manage Queries window or the More Search Fields window. The WHERE Clause window is accessed from the Advanced Search menu.