Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal
< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7
You are here: Build Queries Visually > Define Criteria > Add Or Conditions

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