SQL Server Transact Basic to Expert - Changing to UpperCase using Upper

This blog shows how to change the complete string to Upper Case using the UPPERfunction in SQL

Example:

SELECT UPPER(Description)
FROM Dbo.Document
WHERE FileName = MyProj.doc'

This returns the document contents in full Upper case string