2011

DescriptionOperator
The value of the selected column is less than the value you enter
in the Value box.
<
The value of the selected column is less than or equal to the value
you enter in the Value box.
<=
The value of the selected column is not equal to the value you enter
in the Value box.
<>
The selected column is linked to the object and contains the spe-
cified value. If you specify multiple values, separate each value with
a comma. Enclose values in single quotes, for example, '1','2','3'.
IN
The selected column is linked to the object and is empty. Do not
enter a value in the Value box.
IS NULL
The selected column is linked to the object and contains part of
the value specified. Applies to string (character) data types only.
Use the percent sign (%) as a wild-card character in the Value box.
LIKE
For information on the wild-card characters supported by your database
system, refer to the documentation for your database system software.
Value
Specify the value to search for. To select from a list of existing values in the
column, click
. To use wild-card characters for string values, select
LIKE.
For example, type B% to find all values that begin with the letter B.
Add
Add the condition line to the SQL Filter list.
Update
Replace the selected condition in the SQL Filter list with the new condition.
To use a filter you previously defined for this table, click History at the bottom
of the screen. Select the filter from the list.
Table Filter dialog box | 1695