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

 

Next Recommended Reading Case Statement in SQL Server