SQL Function: UPPER()

Definition:

Return provided string in uppercase.


Command Syntax:

UPPER(string)

Command Example:

Table STUDENT
SID SNAME CLASS CNO
010122 Chris Wong 1A 5
010142 Nico Lin 1C 7
010133 Amy Chan 2D 12

Input:
SELECT UPPER(SNAME) AS NAME FROM STUDENT;

Output:
NAME
Chris Wong
Nico Lin
Amy Chan


‘HTML does not initialize uppercase tag.’By secondary 6 student

Comments