LOWER() function in SQL Server
LOWER() :
This function in SQL Server helps to convert all the letters of the given string to lowercase. If the given string contains characters other than alphabets, then they will remain unchanged by this function.
Syntax :
LOWER( str )
Parameters :
- str – The string which will be converted to lowercase
Result :
This function returns the lowercase string.
Example-1 :
Using LOWER() function with Uppercase string.
SELECT LOWER('WAKE UP AND TAKE UP') As New;
Output :
New |
---|
wake up and take up |
Example-2 :
Using LOWER() function with Mixed case string.
SELECT LOWER('EvERy DAy iS A NEW day') As New;
Output :
New |
---|
every day is a new day |
Example-3 :
Using LOWER() function with Select statement. Now, let’s Create Players table and Insert value in it.
Create table Players ( Firstname varchar(40), Lastname varchar(40), Country varchar(40) )
Inserting Value :
Insert into Players values ('VIRAT', 'KOHLI', 'INDIA')
Output :
The table will look like as follow.
Firstname | Lastname | Country |
---|---|---|
VIRAT | KOHLI | INDIA |
Use of LOWER() function :
SELECT LOWER(Firstname) As firstname, Lastname, Country FROM Players;
Output :
firstname | Lastname | Country |
---|---|---|
virat | KOHLI | INDIA |
Example-4 :
Using LOWER() function in a Variable.
DECLARE @text VARCHAR(45); SET @text = 'LIFE IS AWESOME IF YOU LIVE '; SELECT @text, LOWER(@text) AS Lower;
Output :
text value | Lower |
---|---|
LIFE IS AWESOME IF YOU LIVE | life is awesome if you live |
Contact Us