The LCASE() Function
The LCASE() function converts the value of a field to lowercase.
SQL LCASE() Syntax
SELECT LCASE(column_name) FROM table_name;
Syntax for SQL Server
SELECT LOWER(column_name) FROM table_name;
Example
SELECT LCASE(CustomerName) AS Customer, City
FROM Customers;
FROM Customers;