# CASE Expression

*noun*

say it: **“KAYS ek-SPRESH-un”** **/keɪs ɪkˈsprɛʃən/**

A SQL expression that picks a value by checking conditions in order, like an if-else inside a query.

## What does **CASE Expression** do in a relational database?

**CASE Expression** — An expression that chooses a result by evaluating conditions in order.

```sql
SELECT order_id,
       CASE
           WHEN total_amount >= 100 THEN 'large'
           ELSE 'standard'
       END AS size
FROM purchase_order;
```

## In a sentence

- “A **CASE** expression labels each product Cheap, Fair or Pricey.”

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/case-expression
