U.M. (Windows)

Creating a database file 2-17
Comparison operators
Comparison operators compare two expressions and return either true
or false (sometimes called a Boolean expression). Arithmetically, a
result of true equals 1 and a result of false equals 0.
Logical operators
When you want FileMaker Pro to perform a calculation based on two or
more conditions, use logical operators to describe such conditions.
Symbol Name Definition Examples
= Equal to True when both items
are equal
38=39 returns false
38=38 returns true
<> Not equal to True when the items are
not equal
38<>39 returns true
38<>38 returns false
> Greater than True when the value on
the left exceeds the
value on the right
5>6 returns false
19>1 returns true
< Less than True when the value on
the left is less than the
value on the right
5<6 returns true
19<1 returns false
>= Greater than or
equal to
True when the value on
the left is greater than or
equal to the value on
the right
5>=6 returns false
5>=5 returns true
<= Less than or
equal to
True when the value on
the left is less than or
equal to the value on
the right
5<=6 returns true
19<=18 returns false
Choose FileMaker Help Index from the Help menu, and then type:
E comparison operators
Operator Definition Example
AND True only when both of two values are
true. The result is:
1 true when true AND true
1 false when false AND true
1 false when false AND false
InvoiceTotal<100 AND
SalesTax<6
?