Beginner

233. UPPER Function

Learn how to convert text values into uppercase characters.

📘 Lesson 233 of 728 ⏱ 8 min 🎯 Beginner

The UPPER function converts alphabetic characters in a text value to uppercase.

Standardizing text case makes data easier to compare, display, search, and categorize.

Convert department names to uppercase.

SQL 
SELECT
    UPPER(Department) AS DepartmentName
FROM Employees;

UPPER is useful in data cleansing, reporting, text normalization, and consistent category matching.

  • UPPER converts text to uppercase.
  • It is useful for standardization.
  • It can help with text comparison.
  • Numbers are generally unaffected.
  • It can be combined with TRIM.
What does UPPER do?

UPPER converts alphabetic characters in a string to uppercase.

Why use UPPER in data cleansing?

It helps standardize text values that may have inconsistent capitalization.

Have you finished this lesson?

Introduction to SQL – All Lessons