Assigning Query Conditions
When you add a field to the Query Builder Conditions tab, the Assign Condition dialog box appears for that field.
To assign
- Open Query Builder.
- Click the Conditions tab
- Add a condition statement.
The Assign Condition dialog box opens.
- Select an Operator.
- In the Value Is box, enter 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 Case Sensitive Compare 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 necessary, select Use Value as a Literal.
- Click OK.