convert text to uppercase in sql server code example

Example 1: uppercase and lowercase in sql

select UPPER('converted to upper');
select LOWER('CONVERTED TO LOWER');

SELECT UPPER(FIRST_NAME) , LOWER(LAST_NAME)
FROM CUSTOMERS ;