what is the use of LOWER() and UPPER() function in SQL server?
by
Narain_Siddharth
on
Jun 01, 2011
Category:
SQL Server
|
Level:
Beginner
|
Views:
115
|
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.
|
Like this question? Bookmark and Share:
« Previous Question | Next Question »
|
|
|
|
No Response found!
|
|
|