# Types of Filters

Filter numbers and dates with comparison operators, text with LIKE patterns, lists with IN, ranges with BETWEEN, and missing values with IS NULL.

![Cheat sheet: Types of Filters](https://fsdtrainingmedia.blob.core.windows.net/public/images/2026/11/20d1da65ab7b452182c079a1b2edb4c5.webp)

- Category: SQL
- Level: Apprentice
- Tags: BETWEEN Predicate, IN Predicate, IS NULL Predicate, LIKE Predicate, NULL (database), sql, t-sql, Wildcard Character
- Updated: November 3, 2026

Source: https://www.ask-codey.com/cheat-sheets/where-in-t-sql-types-of-filters-cheat-sheet