Beginner

198. LOWER Function

Learn how to convert text values to lowercase using SQL.

📘 Lesson 198 of 728 ⏱ 7 min 🎯 Beginner

The LOWER function converts alphabetic characters in a text value to lowercase.

Lowercase standardization is useful when preparing consistent text for analysis and comparison.

Convert customer email addresses to lowercase for standardized output.

SQL 
SELECT
    LOWER(Email) AS Email
FROM Customers;

LOWER is commonly used in email normalization, text matching, data cleaning, and reporting.

  • LOWER converts text to lowercase.
  • It is useful for text standardization.
  • It can be used with SELECT expressions.
  • It is often used with text comparisons.
  • Collation and database behavior can affect comparisons.
What does LOWER do?

LOWER converts alphabetic characters in a text value to lowercase.

Why convert text to lowercase?

Lowercase conversion can standardize values and make certain text comparisons more consistent.

Have you finished this lesson?

Introduction to SQL – All Lessons