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
SQL Server Transact Basic to Expert - Changing to UpperCase using Upper
SQL Server Transact Basic to Expert - Changing to UpperCase using Upper

Join the conversation! Your thoughts help the community grow.