Assigning Query Conditions

When you add a field to the Query Builder Conditions tab, the Assign Condition window is displayed for that field.

To assign:

Open Query Builder.
Select the Conditions tab.
Add a condition statement.
The Assign Condition window displays.
Select an Operator.
In the Value Is field, specify a value or click Browse to select a value.

If you selected "In" as an operator, the values must have quotation marks around each entry.
Select the Case Sensitive Compare check box to use capitalization as part of the condition.

If you are using Microsoft SQL Server, the Case Sensitive Compare option is not applicable. All queries are case insensitive.
If required, select Use Value as a Literal check box.
Click OK.