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:

If you reverse engineer a query that contains a Where clause, it displays in a Global Where clause bubble on the Diagram pane rather than the Where Condition field below the Diagram pane. You can double-click the Global Where Clause bubble in the Diagram pane, or can click to edit it.
This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To set a Where condition

Select a column from a table in the Diagram tab.
Select the Where Condition field below the column and click .

Notes:
- You can also use the Where Condition to add the same column twice to the query.
- The editor starts with the column name.

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:

You can use variables in a Where condition. See Set Bind Variables for more information.
Click Subquery to add a subquery. See Add Subqueries for more information.
To remove a Where condition, open the Where Condition window and click Remove.