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 > Set Where Conditions

Set Where Conditions

You can use a Where condition to filter data returned by a query or to join sets of data.

Notes:

To set a Where condition

  1. Select a column from a table in the Diagram tab.

  2. Select the Where Condition field below the column and click .  

    Notes:

  3. Complete the fields as necessary. Review the following for additional information:

    Form Page Description

    Field

    Select an operator or predicate to use in this condition.

    Value 1 Type

    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.

    Notes:

    • You can also specify a bind variable in this field using ":variable". If you enter a variable, you are prompted to enter a value for the variable when you execute the statement.
    • The Value 2 Type field is only available if you select the Between predicate.

    Formula Page

    Description

    Functions

    Perform an incremental search or select a function and then select a column on which to perform the function.

    Operators

    Double click an operator or predicate to use in this condition.

    Columns and calculated fields

    Double-click a column to apply a function or operator against.

    Date Range Page

    Description

    Date Range Values

    Select a date range to apply to this column. See Set Date Ranges for more information.

    Note: This tab only displays if you select a column that has a Date data type.

Tips:

 

Related Topics

Build Queries Visually 

Find Lookup Tables 

Add Subqueries

Add Or Conditions