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