Beginner

306. UPPER Function

Learn how to convert text values into uppercase characters.

📘 Lesson 306 of 728 ⏱ 8 min 🎯 Beginner

The UPPER function converts alphabetic characters in a string to uppercase.

Standardizing text capitalization improves consistency in reports, comparisons, and data-cleaning processes.

Convert department names to uppercase.

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

UPPER is useful in reporting, data cleaning, category standardization, and text comparisons.

  • UPPER converts text to uppercase.
  • It helps standardize categories.
  • It is useful in reports.
  • It can support text comparisons.
  • Non-alphabetic characters are generally unchanged.
What does UPPER do?

UPPER converts alphabetic characters in a string to uppercase.

Why standardize text case?

Standardizing text case can reduce inconsistencies when comparing or reporting categorical values.

Have you finished this lesson?

Introduction to SQL – All Lessons