LOWER () function changes all characters in a string to lowercase.  

Table: Orders

OrderID	Customer	Employee	Order Date	ShippedVia	Freight	ShipCountry
10248	Wilman Kala	Buchanan, Steven	04-07-1996	Federal Shipping	$32.38	France
10249	Hanari Carnes	Peacock, Margaret	08-07-1996	United Package	$65.83	Brazil
10250	Hanari Carnes	Leverling, Janet	08-Jul-1996	United Package	$58.17	Brazil
10251	Chop-suey Chinese	Buchanan, Steven	11-Jul-1996	United Package	$22.98	Switzerland
10252	Richter Supermarket	Dodsworth, Anne	12-Jul-1996	Federal Express	$148.33	Switzerland

Let's take a look at the following SQL statement:

SELECT LOWER (Customer) AS CUSTOMER_NAME FROM Orders;

The above SQL statement will return results as follow:

CUSTOMER_NAME

wilman kala

hanari carnes

hanari carnes

chop-suey chinese

richter supermarket

.