Convert Text to UpperCase and LowerCase in SQL

In this post we will see how to convert text to UpperCase or LowerCase in SQL.

UpperCase

Write the following script in SQL Server Query Analyser.

Selectupper('This is going to be converted to upper case')AsText

When we execute the preceding command we get the output in Upper Case.



LowerCase

Write the following script in SQL Server Query Analyser.

Select lower('THIS IS GOING TO BE CONVERTED TO LOWER CASE')AsText

When we execute the preceding command we get the output in lower Case.



We just saw how to convert text to lower case in SQL.