Operator

Description

+

Adds two numeric fields or values

-

Subtracts two numeric fields or values

*

Multiplies two numeric fields or values

/

Divides two numeric fields or values

&

Concatenates  two string fields or values

()

Separates expressions or operations

“ ”

Surrounds a text string of characters

=

Checks that two fields or values are equal

<>

Checks that two fields or values are not equal

>

Checks that a field or value is strictly greater than another

<

Checks that a field or value is strictly less than another

>=

Checks that a field or value is greater than or equal to another

<=

Checks that a field or value is less than or equal to another

AND

Combines two Boolean fields or values with the logical AND operator

OR

Combines two Boolean fields or values with the logical OR operator

NOT

Returns the opposite logical value of a Boolean field or value

TRUE

Returns the logical value TRUE (used mainly in calculated fields)

FALSE

Returns the logical value FALSE (used mainly in calculated fields)