SQL Function: LOWER()

Definition:

Return provided string in lowercase.

---

Command Syntax:

LOWER(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 LOWER(SNAME) AS NAME FROM STUDENT;

Output:

NAME
Chris Wong
Nico Lin
Amy Chan

---

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