Specifications

Operators used in InfoMaker expressions
620 InfoMaker
When you write an expression, you can use the following relational operators
(more information about
LIKE, IN, and BETWEEN follows the table):
Table 23-7: Using expressions with relational operators
Special characters for
operations with strings
You can use the following special characters with relational operators that take
string values:
Table 23-8: Special characters for use in expressions with relational
operators
LIKE and NOT LIKE
operators
Use LIKE to search for strings that match a predetermined pattern. Use NOT
LIKE to search for strings that do not match a predetermined pattern. When
you use LIKE or NOT LIKE, you can use the % or _ characters to match
unknown characters in a pattern.
Operator Meaning Example
= Is equal to Price = 100
> Is greater than Price > 100
< Is less than Price < 100
<> Is not equal to Price <> 100
>= Greater than or equal to Price >= 100
<= Less than or equal to Price <= 100
NOT = Is not equal to Price NOT= 100
LIKE Matches this specified
pattern.
Emp_lname LIKE 'C%' OR
Emp_lname LIKE
'G%'
IN Is in this set of values. Dept_id IN (100, 200, 500)
BETWEEN Is within this range of
values. The range includes
the first and last values.
Price BETWEEN 1000 AND
3000
NOT LIKE Does not match this
specified pattern.
Emp_lname NOT LIKE 'C%'
AND Emp_lname NOT LIKE
'G%'
NOT IN Is not in this set of values. Dept_id NOT IN (100, 200, 500)
NOT BETWEEN Is outside this range of
values. The range includes
the first and last values.
Price NOT BETWEEN 1000
AND 2000
Special character Meaning Example
% (percent) Matches any group of
characters.
Good% matches all names that
begin with Good.
_ (underscore) Matches any single
character.
Good _ _ _ matches all 7-letter
names that begin with Good.