Filtering BlockBuster Data
You can use operational signs and expressions to filter the data on the grids.
On the screen toolbar, click the Filter button: 
The following table provides definitions of the operational signs and expressions used in filtering data.
| Filter | Description |
|---|---|
| > | Searches for data with values greater than that stated. |
| < | Searches for data with values less than that stated. |
| = | Searches for data with values equal to that stated. |
| () | Groups expressions when embedded multiple conditions apply. |
| “ ” | Searches for data matching the criteria enclosed by the quotation marks. |
| and | Enters multiple criteria to narrow a search because all criteria must be met for example, "BURG" and "LAKE" and "GOAL" |
| or | Enters multiple criteria to broaden a search because any of the criteria can be met, for example, “BURG” or “LAKE” or “GOAL” |
| not | Excludes data from a search result set for example, “BURG” not “LAKE” |
| null | Displays fields which have no data in them. |
| not null | Displays fields which have data in them. |