Skip to main content
SQL • LESSON 133

UPPER

How can we convert employee names to uppercase?

Advanced3 Minutes1460 XP
🤔 THE QUESTION

How can we convert employee names to uppercase?

💡 WHAT IS IT?

UPPER() converts all characters in a string to uppercase.

🎯 WHAT IS IT USED FOR?

Standardizing country codes, case-insensitive comparison normalization, formal output formatting.

💻 EXAMPLE
SELECT UPPER(name) AS employee_name
FROM employees;

🎯 Mission Objectives

Practice typing production-grade SQL code for UPPER.

  • UPPER() function
  • Case standardization
  • String transformation
  • Text formatting