LOWER

Convert the text to lowercase.

SELECT LOWER(‘SQL Tutorial is FUN!’);

Definition and Usage

The LOWER() function converts a string to lowercase.

Note: Also see the UPPER() function.

LOWER(text)

Parameter	Description
text	Required: The string to be converted.

Works in:

SQL Server (since 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse

Convert the text in “CustomerName” to lowercase.

SELECT LOWER(CustomerName) AS LowercaseCustomerName
FROM Customers;