How to convert lowercase and uppercase characters in sql

SELECT UPPER(ColumnName) FROM TableName

SELECT UPPER(EmpName) as EmpName FROM emp


SELECT LOWER(ColumnName) FROM TableName

SELECT LOWER(EmpName) as EmpName FROM Emp