Overview

Comparison Operators

Like

Like is a wildcard value. This will return values that contain a pattern match.

Example 1

“Suburb” Like B (will return Broadview, Broadmeadows, Brighton)

Not Like

Displays records if a condition is not TRUE or don’t match the selected pattern match.

Example 1

“Surname” NOT LIKE Smith (will return other surnames like: Jones, Brown, Davies except for Smith)

Field Equals (=)

Compares the contents of one field with another field. Note that the fields used here do not need to be added to the report

Example 1

Field Not Equals !=

Example 1

Field Greater Than (>)

Example 1

Field Less Than (<)

Example 1

Field Greater Than Equal To (>=)

Example 1

Field Less Than Equal to (<=)

Example 1

_{Advanced Report Builder | Order By Clauses | Alternative Data Formats | Bulk Student Select | Complex Filter Clause Operators | Nested Operators Using Brackets | User-Defined Parameters | Summarise Data | Generic Report Query}