Operators

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:

String Numerical Date Logic Expression
equal to        
not equal to        
between        
not between        
greater than        
greater than or equal to        
less than        
less then or equal to        
containing        
not containing        
beginning with        
ending with