UPPER()

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

Syntax

UPPER( string )

Data Types
Return	string
String	String

The following example uses the UPPER function to convert the value of StockName to all upper-case characters:

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