lower and upper in sql code example
Example 1: uppercase and lowercase in sql
select UPPER('converted to upper');
select LOWER('CONVERTED TO LOWER');
Example 2: lower case in sql
SELECT UPPER(FIRST_NAME) , LOWER(LAST_NAME)
FROM CUSTOMERS ;
select UPPER('converted to upper');
select LOWER('CONVERTED TO LOWER');
SELECT UPPER(FIRST_NAME) , LOWER(LAST_NAME)
FROM CUSTOMERS ;