> For the complete documentation index, see [llms.txt](https://docs.silverband.com.au/home/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.silverband.com.au/home/paradigm-knowledge-base/generating-reports/workflows/advanced-report-builder/complex-comparison-operators.md).
# Complex Comparison Operators
## Overview
Now that you’ve learned some basic filter clause operators from this knowledge article: [Basic Comparison Operators](/home/paradigm-knowledge-base/generating-reports/workflows/introduction-to-report-builder/basic-comparison-operators.md), you can add more complex filters by using the operators mentioned in this article.
The following operators are mostly used to compare two fields:
## **Field equal (=)**
Compares the contents of one field if the same or equal to another field.
**Example 1**
> “Country” Field Equals (=) “Billing Country” will return data which has the same country and billing country information
**Sample Output**
## **Field is not equal to (!=)**
Will return data or information with a field not equal to the other field.
**Example 1**
> “Country” Field Not Equals (=) “Billing Country” will return data which has a country not equal or the same as the billing country
**Sample Output**
## **Field is greater than (>)**
Will return data or information with a field greater than the other field.
**Example 1**
> “Withdrawal Date” Field Greater Than (>) “Dest Census Date will return data which has a withdrawal date greater than the Dest Census Date.
**Sample Output**
## **Field Less Than (<)**
Will return data or information with a field less than the other field.
**Example 1**
> “Amount Paid” Field Less Than (<) “Amount Due” will return data which has an amount paid less than the amount due.
**Sample Output**
## **Field Greater Than Equal To (>=)**
Will return data or information with a field greater or equal to the other field. The difference between this and the Field Greater Than (>) operator is that this would include the field which is also equal to the other field.
**Example 1**
> “Withdrawal Date” Field Greater Than Equal To (>=) “Dest Census Date will return data which has a withdrawal date greater than or equal to the Dest Census Date.
**Sample Output**
## **Field Less Than Equal To (<=)**
Will return data or information with a field less than or equal to the other field. The difference between this and the Field Less Than (>) operator is that this would include the field which is also equal to the other field.
**Example 1**
> “Amount Paid” Field Less Than Equal To (<=) “Amount Due” will return data which has an amount paid less than or equal to the amount due.
**Sample Output**
## Custom
Allows you to put an SQL query inside the **Value** column
**Example 1**
> “Amount Paid” custom query to check paid amount between $500 and $1000 (This will return students with **Amount Paid** in between 500 and 10000).
**Sample Output**