Home > Interview Questions > SQL Server > what is the use of LOWER() and UPPER() function in SQL server?

what is the use of LOWER() and UPPER() function in SQL server?

by Narain Siddharth   on 01/06/2011   Category: SQL Server   |  Level: Beginner   |  Views: 1646    |  Points: 25     |  Silver 


The lower() function is used to convert the upper case character to lower case and upper() function is used to convert lower to upper case for specific given string or column. see the sample below.

SELECT UPPER(first_note) AS Note1, 
LOWER(sec_note) AS Note2
FROM employee
//results like as shown below


Note1 Note2
-------------------------------------------
THIS IS TEST MESSAGE. this is test message.
THIS IS TEST MESSAGE. this is test message.
THIS IS TEST MESSAGE. this is test message.
THIS IS TEST MESSAGE. this is test message.
THIS IS TEST MESSAGE. this is test message.



« What is the use of SQL profiler?
» What is the use of REVERSE() function in SQL server?
Post Question  |  Question Home

Recent Posts

User Responses


No response found, be the first to review this question.

Submit feedback about this code snippet

Please sign in to post feedback

Latest Posts