Convert expression into LOWER / UPPER case in sql

Convert expression into LOWER / UPPER case in sql:



You can make use of lower() function to convert expression in lower case



SELECT LOWER(FIRST_NAME_COLUMNNAME)

FROM TABLE





You can make use of upper() function to convert expression in lower case

SELECT UPPER(FIRST_NAME_COLUMNNAME)

FROM TABLE