INITCAP converts text so that the first character of each word is typically uppercase and the remaining characters are lowercase, depending on database behavior.
Properly formatted names and labels make reports easier to read and more professional.
Format employee names for presentation in a report.
SELECT
INITCAP(EmployeeName) AS FormattedName
FROM Employees;INITCAP can be useful for customer names, employee names, city names, and presentation-ready labels.
- INITCAP formats the first character of words.
- It is useful for presentation text.
- It can standardize names.
- Function availability varies.
- Exact behavior depends on the database.
What does INITCAP do?
INITCAP typically capitalizes the first letter of each word and converts remaining letters to lowercase.
Where is INITCAP useful?
It is useful for formatting names, locations, and other presentation-ready text.