LCase Syntax:
SELECT LCASE(column_name)
FROM table_name
Students table:
| ID | NAME | State |
|---|---|---|
| 1 | Tom | Arizona |
| 2 | Linda | Texas |
| 3 | Helen | Florida |
| 4 | Robert | California |
LCase Example:
SELECT name, LCASE(name)
FROM students;
LCase Result:
| Name | LCASE(name) |
|---|---|
| Tom | tom |
| Linda | linda |
| Helen | helen |
| Robert | robert |