Returns a character expression with lowercase character data converted to uppercase.
UPPER ( character_expression )
An expression of character or binary data that can be implicitly converted to nvarcharorntext.
The following example queries the Customerstable and returns the names of the companies in uppercase.
SELECT [Customer ID], UPPER([Company Name]) AS Expr1
ORDER BY [Company Name]