# IS NULL Predicate

*noun*

say it: **“IZ NUL PRED-ih-kit”** **/ɪz nʌl ˈprɛdɪkɪt/**

A SQL condition that checks whether a value is missing, written IS NULL or IS NOT NULL.

## What does **IS NULL Predicate** do in a relational database?

**IS NULL Predicate** — A predicate testing whether a value is NULL.

```sql
SELECT customer_id
FROM customer
WHERE phone_number IS NULL;
```

## In a sentence

- “WHERE Region **IS NULL** finds the customers with no region.”

Level: Apprentice · [More SQL terms at this level](https://www.ask-codey.com/glossary?category=sql&level=2)

Updated: November 9, 2026

Source: https://www.ask-codey.com/glossary/is-null-predicate
