The LOWER function converts the value of a field to lowercase. The LOWER function is used for SQL Server. Other SQL platforms may use the LCASE function.
Employees Table
employeeID | employeeName | age |
|---|---|---|
| 1000 | John Smith | 40 |
| 1001 | Fred White | 27 |
| 1002 | Jane Scott | 53 |
| 1003 | Samuel Williams | 31 |
In this example, we want to find to see convert the employeeName field to lowercase in the query results.
Syntax
SELECT LOWER(column_name)
FROM TableExample
SELECT LOWER(employeeName) as [employee name]
FROM employeesResults
| employee name |
|---|
| john smith |
| fred white |
| jane scott |
| samuel williams |
The SQL LOWER function is used to convert a given field in a table to lowercase characters.
