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 Table |
Example
SELECT LOWER(employeeName) as [employee name]
FROM employees
|
Results
| 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.
Did you find the page informational and useful? Share it using one of your favorite social sites.
Recommended Books & Training Resources
