Beginner

53. LOWER Function

Learn how to convert text values into lowercase characters using SQL.

📘 Lesson 53 of 728 ⏱ 6 min 🎯 Beginner

The LOWER function converts alphabetic characters in a text value to lowercase. It is commonly used for text standardization, formatting, and consistent comparisons.

Text data may contain inconsistent capitalization. LOWER can help standardize values so they are easier to compare, clean, and analyze.

If customer email addresses are stored using different capitalization, LOWER can convert them to a consistent lowercase format for analysis.

SQL 
SELECT
    EmployeeName,
    LOWER(Department) AS DepartmentName
FROM Employees;

LOWER is useful for email analysis, customer data cleaning, text standardization, reporting, and search preparation.

  • LOWER converts text to lowercase.
  • LOWER is a string function.
  • It can be used in SELECT expressions.
  • It can help standardize text.
  • It is useful for text comparison and cleaning.
What does LOWER do in SQL?

LOWER converts alphabetic characters in a text value to lowercase.

Why is LOWER useful in data analysis?

It can standardize text values and help create consistent output or comparisons.

Have you finished this lesson?

Introduction to SQL – All Lessons