Function Reference

UCASE

PostgreSQL equivalent:

A synonym for UPPER: converts all letters of a string to uppercase.

MySQL 8.1
UCASE(str)

Parameters

strVARCHAR
Source string

Return value

A string in uppercase

Examples

A string in uppercase

MySQL 8.1
SELECT UCASE('SQL Academy') AS upper_case;
upper_case
SQL ACADEMY

Capital first letter

MySQL 8.1
SELECT good_name,
	CONCAT(
		UCASE(LEFT(good_name, 1)),
		SUBSTRING(good_name, 2)
	) AS capitalized
FROM Goods
LIMIT 5;
good_namecapitalized
apartment feeApartment fee
phone feePhone fee
breadBread
milkMilk
red caviarRed caviar

See also