LOWER()

Scalar. Returns a given string with all characters converted to lower case.

Syntax

LOWER( string )

Data Types
Return	string
String	String

The following example uses the LOWER function to convert a stock name to all lowercase characters.

INSERT INTO OutStream
SELECT LOWER(Trades.StockName)
FROM Trades;