Open topic with navigation

Learn more about Toad for SQL Server at Dell Software Find solutions and downloads at the Toad for SQL Server Support Portal

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

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

2. 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.

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:

• You can use variables in a Where condition. See Using 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.

Related Topics

Build Queries Visually 

Find Lookup Tables 

Add Subqueries

Add Or Conditions 

of