Convert Upper and Lower Case in Sql Server

It will return upper case :

SELECT UCASE (ColumnName) FROM TableName

It will return lower case :

SELECT LCASE (ColumnName) FROM TableName