Toad for DB2 7.4 - Installation Guide

Add OR Conditions

From the Criteria tab in the Query Builder, you can add an Or condition as part of a Where condition.  

To add an Or condition

1. Set a Where condition in the Diagram tab. See Set Where Conditions for more information.

2. Select the Or field below the column and click .  

3. Review the following for additional information:

   Field	Select an operator or predicate to use in this condition.
   Value 1 Type	Select whether the expression is a column or constant. After selecting this option, select the column name or enter a constant in the field.
   Value 2 Type	Select whether the expression is a column or constant. After selecting this option, select the column name or enter a constant in the field. This option is only available if you selected the Between predicate.

Tip: To remove an Or condition, open the Or condition window and click Remove.

Related Topics

Build Queries Visually 

Set Where Conditions