Built-In Operators and Functions - Intergraph Smart Instrumentation - Help

=

Equal to

cpmnt_mfr = 'Shell'

>

Greater than

cmpnt_num > 101

<

Less than

item_price < 100

>=

Greater or equal to

cmpnt_num >= 10

=<

Less than or equal to

item_price =< 30

<>

Not equal to

suffix <> 'AA'

AND

Include the following expression in the filter combination

(name <> '') AND (num <> 0)

OR

Accept either the previous or the following expression in the filter combination

(loop = '') OR (line = '')

NOT

Select the value opposite to the following expression

NOT (item_price = 0)

LIKE[value]

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. _ – any single character.

cmpnt_num LIKE '%AA%'

IN

Select a value that is equal to one of those specified in the parentheses

cpmnt_num = IN (101,103)

BETWEEN

Select a value which is within the following interval

item_price BETWEEN 100 AND 500

IS NULL

Contains an undefined value

loop_name IS NULL

IS NOT NULL

Not equal to NULL

cpmnt_name IS NOT NULL