How to combine conditions when OR has precedence (Enterprise Manager)
To combine conditions when OR has precedence
- In the Grid pane, add the data columns you want to search. If you want to search the same column using two or more conditions linked with AND, you must add the data column name to the grid once for each value you want to search.
- Create the conditions to be linked with OR by entering the first one into the Criteria grid column and the second (and subsequent ones) into separate Or ... columns.
- Create the AND condition by entering it once for each OR condition. Place each entry in the same grid column as the OR condition it corresponds to.
Note You can repeat an AND condition by adding it once, and then using the Cut and Paste commands from the Edit menu to repeat it for other OR conditions.
(c) 1988-98 Microsoft Corporation. All Rights Reserved.