SQL Server Transact Basic to Expert - Changing to LowerCase using Lower

This blog shows how to change the complete string to Lowercase using the Lower function in SQL

EXample:

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

This returns the document contents in full lowercase