U.M. (Windows)

2-18 FileMaker Pro User’s Guide
Use AND, OR, or XOR to combine two expressions; use NOT with only
one expression.
Text operators
Use the following text operators with text expressions. (Double
quotation marks indicate a text expression.)
OR True when either of two values is true. The
result is:
1 true when true OR true
1 true when true OR false
1 false when false OR false
InvoiceTotal<100 OR
SalesTax<6
XOR True when either, but not both, of two
values is true. The result is:
1 false when true AND true
1 true when false AND true
1 false when false AND false
InvoiceTotal<100 XOR
SalesTax<6
NOT Changes a value within parentheses from
false to true or from true to false. The
result is:
1 false when NOT(true)
1 true when NOT(false)
NOT InvoiceTotal>1000
Choose FileMaker Help Index from the Help menu, and then type:
E logical operators
Symbol Name Definition Examples
& Concatenation Appends the text string on the
right to the end of the text string
on the left
"XXX" & "ZZZZZ" returns
"XXXZZZZZ"
" " Text constant Marks the beginning and the
end of a text constant. Quotation
marks without text between
them indicate a blank space. If
you enter text into a formula
without using quotation marks,
FileMaker Pro interprets the
text as a field name or function
name. To put a quotation mark
in a text constant, precede it
with another quotation mark.
"Sydney, NSW" returns
Sydney, NSW
"" returns an empty (null)
value
"The report said
""Confidential"" on
the top" returns The report
said "Confidential" on the top
Operator Definition Example
?