+

-

*

/ or \

% or mod

Arithmetic operators for addition, subtraction, multiplication, division, and modulo computation (division remainder)

The other purpose of the addition operator is to concatenate string values. The operation of this operator depends on the context. If one of the operands is not numeric in type, string concatenation will be performed instead of addition.

& or && or and

| or || or or

Logical operators for AND/OR linking of Boolean values

Regardless of the selected notation of these two operators, they always work with conditional evaluation. If the final result is already fixed after evaluation of the left-hand operand, the right-hand operand will no longer be evaluated.

! or not

Logical operator for negation of a Boolean value

== or =

!= or <>

<

>

<=

>=

Comparison operators for checking for the states "equal," "unequal," "smaller," "larger," "smaller/equal," and "larger/equal"

These operators are applicable to numeric values, date values, and text values.

For the comparison of numeric values and the comparison of date values, the left-hand operand and the right-hand operand must both be of the same type. If the operands are not of the same type, a text comparison will be performed which is not case-sensitive.

~

Operator for comparing a string value (left-hand operand) with a wildcard expression (right-hand operand)

The following wildcard characters are allowed:

An expression embedded in / characters will be interpreted as a regular expression, and the text comparison will be performed accordingly. Unlike the comparable macro function RegExIsMatch(), however, this comparison takes place with a fixed default function ignoring case.