SQL LOWER, LCASE Functions

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

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

The SQL LOWER function is used to convert a given field in a table to lowercase characters.