How we Can CONVERT the value of a field to UPPERCASE and LOWERCASE in SQL SERVER

Defination:-The UPPER Function :The UPPER Function convert  the value of a field to UPPERCASE
SYNTAX UPPER() For SQL SEVER
SELECT UPPER(column_name) FROM table_name
EXAMPLE
select UPPER(name) from student
Defination:-The LOWER Function :The LOWER Function convert  the value of a field to LOWERCASE
SYNTAX LOWER() For SQL SEVER
SELECT LOWER(column_name) FROM table_name
EXAMPLE
select LOWER(name) from student