The SQL LCASE() function is used to convert a text or string value to lower case values.
Example Customer Table
The following data table is for example only. Let's use LCASE() function to convert the customer name to all lower case. The column we going to use is the Name column.
ID | Name | Age |
1 | Thomas Anderson | 45 |
2 | Andrew Golden | 38 |
3 | Ken Tom | 30 |
4 | Andrew Golden | 36 |
5 | Timonthy Kirk | 32 |
6 | Kelly Smith | 39 |
Example of Running SQL Query
SELECT ID, LCASE(Name) AS Name, Age FROM Customers
After running the above query, it will return the following result.
ID | Name | Age |
1 | thomas anderson | 45 |
2 | andrew golden | 38 |
3 | ken tom | 30 |
4 | andrew golden | 36 |
5 | timonthy kirk | 32 |
6 | kelly smith | 39 |