SQL LOWER, SQL LCASE

The SQL LOWER, or SQL LCASE function is used to convert a string to lower case. In SQL Server, it uses the LOWER function.

SQL LOWER, SQL LCASE Syntax

SELECT LCASE(string_expression) 
FROM table_name

OR in SQL Server:

SELECT LOWER(string_expression) 
FROM table_name

SQL LOWER, SQL LCASE Example

Table: Employees

We want to convert LastName to lower case:

SELECT EmployeeId, FirstName, LOWER(LastName) AS LastName
FROM Employees

The result will look like: