This dialog is used to filter the items that appear in the Merger Comparison List dialog.
(Filter condition display window)
Type the required filter criteria, or use the field list and operators to build a filter condition.
Field list
This data window displays all the available fields in the current source table. Double-click the required field that you want to include in your filter condition. The field name appears in the filter expression data window above.
Operators & functions
This dialog feature provides you with the built-in operators and functions described. Select the appropriate operator or function button to be added to the filter expression. The result is displayed in the filter expression data window above.
AND
Include the following expression in the filter combination. Example: (name <> '') AND (num <> 0)
OR
Accept either the previous or the following expression in the filter combination. Example: (loop = '') OR (line = '')
NOT
Select the value opposite to the following expression. Example: NOT (item_price = 0)
LIKE
Select a similar value that is similar to the one in the [value] field. You can use the following wildcard characters:
%
Any combination of characters.
_ (underscore)
Any single character
Example: cmpnt_num LIKE '%AA%'
IN
Select a value that is equal to one of those specified in the parentheses. Example: cpmnt_num = IN (101,103)
IS NULL
Contains an undefined value. (Select this option from the drop-down list and then right-click it to add it to the filter expression.) Example: loop_name IS NULL
IS NOT NULL
Not equal to NULL. (Select this option from the drop- down list and then right-click it to add it to the filter expression.) Example: cpmnt_name IS NOT NULL
BETWEEN
Select a value which is within the following interval.
Example: item_price BETWEEN 100 AND 500
=
Equal to.
Example: cpmnt_mfr = 'Shell'
>
Greater than; Example: cmpnt_num > 101
<
Less than; Example: item_price < 100
< >
Not equal to; Example: suffix <> 'AA'
>=
Greater or equal to.
Example: cmpnt_num >= 10
=<
Less than or equal to.
Example: item_price =< 30
SQL Functions drop-down list
This drop-down list contains special functions which are native to the source database. Select the required function from this drop-down list and then right-click it to be added to the filter expression.