Reporting

Arithmetic operators

OperatorDescription
+addition
-subtraction
*multiplication
/division
%the remainder after division
Modmodulus

String Concatenation

OperatorDescription
+

Concatenation, joining strings

Example: Fields.FirstName + " " + Fields.LastName.

Comparison operators

OperatorDescription
<less than
<=less than or equal to
<>not equal to
=equal
>greater than
>=greater than or equal to
Betweenselects a range of data between two values
InCompare to a list of items. The list can be a any collection of objects
Likepattern matching
IS [NOT] NULL

If the value of expression is NULL, IS NULL returns TRUE; otherwise, it returns FALSE.

If the value of expression is NULL, IS NOT NULL returns FALSE; otherwise, it returns TRUE.

Logical/Bitwise operators

OperatorDescription
AndCombines two Boolean expressions and returns TRUE when both expressions are TRUE
NotUsing NOT negates an expression
OrCombines two Boolean expressions and returns TRUE when either of the conditions is TRUE

Using wildcards for operators

Both the * and % can be used interchangeably for wildcard characters in a LIKE comparison. If the string in a LIKE clause contains a * or %, those characters should be escaped in brackets ([]). If a bracket is in the clause, the bracket characters should be escaped in brackets (for example [[] or [&cd;). A wildcard is allowed at the start and end of a pattern, or at the end of a pattern, or at the start of a pattern. For example:

  • "ItemName LIKE '*product*'"
  • "ItemName LIKE '*product'"
  • "ItemName LIKE 'product*'"

Wildcard characters are not allowed in the middle of a string. For example, 'te*xt' is not allowed.