LCASE() Function in sql server

Introduction:

The LCASE() function converts the value of a field to lowercase.

Syntax:

SELECT LCASE(column_name) FROM table_name;

Example:

SELECT LCASE(CustomerName) AS Customer, City
FROM Customers;