Operators enable you to define the circumstances in which a condition is deemed to be true.  The operators available depend on the data type being operated upon, so only the appropriate operators will be available. For example, a logical condition can only be true or false, so it cannot be greater than anything making the greater than operator inappropriate for that data type.

 

The table below shows a list of operators and the data with which they can be used:

 

Operator

Types of data

Description

String

Numerical

Date

Logic

Expression

equal to

If the first value is equal to the second, then the condition is true.

 

not equal to

If the first value is not equal to the second, then the condition is true.

 

between

 

 

If the first value is in the range, then the condition is true.

 

not between

 

 

If the first value is not in the range, then the condition is true.

 

greater than

 

 

If the first value is greater then the second value, then the condition is true.

 

greater than or equal to

 

 

If the first value is greater then the second value of equal to the second value, then the condition is true.

 

less than

 

 

If the first value is less then the second value, then the condition is true.

 

less then or equal to

 

 

If the first value is less then the second value or equal to the second value, then the condition is true.

 

containing

 

 

 

 

If the first value contains the second value, then the condition is true. This operator is used only for strings.

 

not containing

 

 

 

 

If the first value does not contain the second value, then the condition is true. This operator is used only for strings.

 

beginning with

 

 

 

 

If the first value starts with the second value, then the condition is true. This operatior is used only for strings.

 

ending with

 

 

 

 

If the first value ends with the second value, then the condition is true. This operator is used only for strings.