SQL Server

Convert Text to UpperCase and LowerCase in SQL

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.

 
Ebook Download
View all
Learn
View all
Membership not found