Visual SQL Query Builder Dialog, Where Tab

Setting	Description
Selected Table(s)	Displays the table or tables which are currently selected.
Available Fields	Displays the fields of the table displayed in the Table dialog. Note: If there are joined tables selected, the table's alias appears in front of each field's name, to distinguish fields from different tables.
Where Fields	Displays the field selected in Available Fields.
Operator	Displays the operator selected in Common Operators or Additional Operators.
Value	Displays the value selected in Value.
And/Or	Displays AND if And is clicked and displays OR if Or is clicked.
Common Operators	Clicking an operator enters it into the Operator column of the Where Fields list box. Query statements containing these operators return database records that comply with the operators. < ? Generates a “<” character, meaning that the selected column (for example, TAXES) has a value less than the number keyed into the Value text box. > ? Generates a “>” character, meaning that the selected column (for example, TAXES) has a value greater than the number keyed into the Value text box. <= ? Generates “<=” characters, meaning that the selected column (for example, TAXES) has a value less than or equal to the number keyed into the Value text box. >= ? Generates “>=” characters, meaning that the selected column (for example, TAXES) has a value greater than or equal to the number keyed into the Value text box. = ? Generates a “=” character, meaning that the selected column (for example, TAXES) has a value equal to the number keyed into the Value text box. <> ? Generates “<>” characters, meaning that the selected column (for example, TAXES) has a value not equal to the number keyed into the Value text box.
Additional Operators	Contains the following list of additional query operators. In ? Generates a phrase that the selected column (for example, OWNER) has a value equal to any member in parentheses (for example, (1, 2, 3, 4)). Not In ? Generates a phrase that the selected column (for example, OWNER) has a value not equal to any member in parentheses (for example, (1, 2, 3, 4)). Like ? Generates a phrase that the selected column (for example, OWNER) has a value which matches what is keyed into the Value text box (for example, 'SMITH'). Not Like ? Generates a phrase that the selected column (for example, OWNER) has a value which does not match what is keyed into the Value text box (for example, 'SMITH'). Contains ? Generates a phrase that the selected column (for example, OWNER) has a value which contains what is keyed into the Value text box (for example, 'SMITH'). Begins With ? Generates a phrase that the selected column (for example, OWNER) has a value which begins with what is keyed into the Value text box (for example, 'SAM'). Ends With ? Generates a phrase that the selected column (for example, OWNER) has a value which ends with what is keyed into the Value text box (for example, `SON'). Matches ? Generates a phrase that the selected column (for example, OWNER) has a value which matches what is keyed into the Value text box (for example, `SMITH'). Is Null ? Generates a phrase that the selected column (for example, TAXES) has a NULL value. Between ? Generates a phrase that the selected column (for example, TAXES) has a value between the two numbers keyed into the Value text box, separated by an `and'. For example, to define the search condition “lot areas between 4000 and 8000 sq.ft.,” choose the “Between” operator and into the Value text box key in “4000 and 8000”. Is Found In the List ? Generates a phrase that the selected column (for example, TAXES) has a value equal to what is keyed into the Value text box. Does Not Contain ? Generates a phrase that the selected column (for example, TAXES) does not have a value equal to what is keyed into the Value text box. Does Not Begin With ? Generates a phrase that the selected column (for example, OWNER) has a value which does not begin with what is keyed into the Value text box (for example, `SMITH'). Does Not End With ? Generates a phrase that the selected column (for example, OWNER) has a value which does not end with what is keyed into the Value text box (for example, `SMITH'). Does Not Match ? Generates a phrase that the selected column (for example, TAXES) has a value which does not match what is keyed into the Value text box. Is Not Null ? Generates a phrase that the selected column (for example, TAXES) has a non-blank value. Not Between ? Generates a phrase that the selected column (for example, TAXES) has a value which is not between the two numbers keyed into the Value text box, separated by a comma. Is Not Found In List ? Generates a phrase that the selected column (for example, TAXES) does not have a value equal to what is keyed into the Value text box.
Value	Enters an alphanumeric value into the Value field of the Where Fields list box. This value is the value against which the selected column is compared using the selected operator.
And	Enters AND into the And/Or field of the Where Fields list box. This adds an AND clause to the query being generated.
Or	Enters OR into the And/Or field of the Where Fields list box. This adds an OR clause to the query being generated.
Clear	Deletes the row selected in the Where Fields list box.
Apply	Adds the WHERE clause defined in the Where tab page into the query being generated in the SQL Select Statement text box.

Selected Table(s)

Displays the table or tables which are currently selected.

Available Fields

Displays the fields of the table displayed in the Table dialog.

Note: If there are joined tables selected, the table's alias appears in front of each field's name, to distinguish fields from different tables.

Where Fields

Displays the field selected in Available Fields.

Operator

Displays the operator selected in Common Operators or Additional Operators.

Value

Displays the value selected in Value.

And/Or

Displays AND if And is clicked and displays OR if Or is clicked.

Common Operators

Clicking an operator enters it into the Operator column of the Where Fields list box.

Query statements containing these operators return database records that comply with the operators.

< ? Generates a “<” character, meaning that the selected column (for example, TAXES) has a value less than the number keyed into the Value text box.
> ? Generates a “>” character, meaning that the selected column (for example, TAXES) has a value greater than the number keyed into the Value text box.
<= ? Generates “<=” characters, meaning that the selected column (for example, TAXES) has a value less than or equal to the number keyed into the Value text box.
>= ? Generates “>=” characters, meaning that the selected column (for example, TAXES) has a value greater than or equal to the number keyed into the Value text box.
= ? Generates a “=” character, meaning that the selected column (for example, TAXES) has a value equal to the number keyed into the Value text box.
<> ? Generates “<>” characters, meaning that the selected column (for example, TAXES) has a value not equal to the number keyed into the Value text box.

Additional Operators

Contains the following list of additional query operators.

In ? Generates a phrase that the selected column (for example, OWNER) has a value equal to any member in parentheses (for example, (1, 2, 3, 4)).
Not In ? Generates a phrase that the selected column (for example, OWNER) has a value not equal to any member in parentheses (for example, (1, 2, 3, 4)).
Like ? Generates a phrase that the selected column (for example, OWNER) has a value which matches what is keyed into the Value text box (for example, 'SMITH').
Not Like ? Generates a phrase that the selected column (for example, OWNER) has a value which does not match what is keyed into the Value text box (for example, 'SMITH').
Contains ? Generates a phrase that the selected column (for example, OWNER) has a value which contains what is keyed into the Value text box (for example, 'SMITH').
Begins With ? Generates a phrase that the selected column (for example, OWNER) has a value which begins with what is keyed into the Value text box (for example, 'SAM').
Ends With ? Generates a phrase that the selected column (for example, OWNER) has a value which ends with what is keyed into the Value text box (for example, `SON').
Matches ? Generates a phrase that the selected column (for example, OWNER) has a value which matches what is keyed into the Value text box (for example, `SMITH').
Is Null ? Generates a phrase that the selected column (for example, TAXES) has a NULL value.
Between ? Generates a phrase that the selected column (for example, TAXES) has a value between the two numbers keyed into the Value text box, separated by an `and'. For example, to define the search condition “lot areas between 4000 and 8000 sq.ft.,” choose the “Between” operator and into the Value text box key in “4000 and 8000”.
Is Found In the List ? Generates a phrase that the selected column (for example, TAXES) has a value equal to what is keyed into the Value text box.
Does Not Contain ? Generates a phrase that the selected column (for example, TAXES) does not have a value equal to what is keyed into the Value text box.
Does Not Begin With ? Generates a phrase that the selected column (for example, OWNER) has a value which does not begin with what is keyed into the Value text box (for example, `SMITH').
Does Not End With ? Generates a phrase that the selected column (for example, OWNER) has a value which does not end with what is keyed into the Value text box (for example, `SMITH').
Does Not Match ? Generates a phrase that the selected column (for example, TAXES) has a value which does not match what is keyed into the Value text box.
Is Not Null ? Generates a phrase that the selected column (for example, TAXES) has a non-blank value.
Not Between ? Generates a phrase that the selected column (for example, TAXES) has a value which is not between the two numbers keyed into the Value text box, separated by a comma.
Is Not Found In List ? Generates a phrase that the selected column (for example, TAXES) does not have a value equal to what is keyed into the Value text box.

Value

Enters an alphanumeric value into the Value field of the Where Fields list box. This value is the value against which the selected column is compared using the selected operator.

And

Enters AND into the And/Or field of the Where Fields list box. This adds an AND clause to the query being generated.

Or

Enters OR into the And/Or field of the Where Fields list box. This adds an OR clause to the query being generated.

Clear

Deletes the row selected in the Where Fields list box.

Apply

Adds the WHERE clause defined in the Where tab page into the query being generated in the SQL Select Statement text box.