LOWER

How can we normalize email addresses to lowercase?

Advanced⏱ 3 Minutes⭐ 1470 XP

🤔 THE QUESTION

How can we normalize email addresses to lowercase?

💡 WHAT IS IT?

LOWER() converts string characters to lowercase for canonical storage and matching.

🎯 WHAT IS IT USED FOR?

Normalizing email logins, case-insensitive joins, URL slug generation.

💻 EXAMPLE

SELECT LOWER(email) AS normalized_email
FROM employees;

Practice typing production-grade SQL code for LOWER.