LCase SQL Tutorial

LCase Syntax:

SELECT LCASE(column_name) FROM table_name

Students table:

IDNAMEState
1TomArizona
2LindaTexas
3HelenFlorida
4RobertCalifornia

LCase Example:

SELECT name, LCASE(name) FROM students;

LCase Result:

NameLCASE(name)
Tomtom
Lindalinda
Helenhelen
Robertrobert