Operators are used to combine expression elements to make certain types of comparisons in an expression.
Operator
|
Function in an Expression
|
+
|
Plus sign for addition.
|
-
|
Minus sign for subtraction
|
*
|
Multiply sign for multiplication
|
/
|
Divide by sign for division
|
||
|
Character string concatenation
|
(
|
Open parenthesis, for grouping operations
|
)
|
Close parenthesis, for grouping operations
|
>
|
Greater than sign, indicating values higher than the comparison
|
<
|
Less than sign, indicating values lower than the comparison
|
=
|
Equal sign, indicating the same value
|
<=
|
Less than or equal to sign, indicating values the same or lower than the comparison
|
>=
|
Greater than or equal to sign, indicating values the same or higher than the comparison
|
<>
|
Not equal to, indicating values higher or lower, but not the same
|
AND
|
AND connective, indicating intersection with one or more conditions to form a compound condition
|
OR
|
OR connective, indicating the union with one or more conditions to form a compound condition
|
NOT
|
NOT connective, indicating a condition is not met
|
,
|
Comma, used to separate elements in a list
|