how to check if a character is uppercase or lowercase in sql code example

Example: uppercase and lowercase in sql

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