UCase SQL Tutorial

UCase Syntax:

SELECT UCASE(column_name) FROM table_name

Students table:

IDNAMEState
1TomArizona
2LindaTexas
3HelenFlorida
4RobertCalifornia

UCase Example:

SELECT name, UCASE(name) FROM students;

UCase Result:

NameUCASE(name)
TomTOM
LindaLINDA
HelenHELEN
RobertROBERT