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