UpperCase

Write the following script in SQL Server Query Analyser.

  1. 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.
  1. 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.