How to enter search conditions (Enterprise Manager)

To enter search conditions

1. If you have not already, add the columns or expressions that you want to search to the Grid pane.

   If you are creating a Select query and do not want the search columns or expressions to appear in the query output, remove them as output columns.

2. Locate the row containing the data column or expression to search, and then in the Criteria grid column, enter a search condition.

   If you do not enter an operator, the Query Designer automatically inserts the equality operator “=“.

The Query Designer updates the SQL statement in the SQL pane by adding or modifying the WHERE clause.