LOWER function in SQL Server
The article will explore and show you how to use the LOWER function in SQL Server to convert letters in a specified string to lowercase.
The article will explore and show you how to use the LOWER function in SQL Server to convert letters in a specified string to lowercase.
Describe
LOWER function in SQL Server converts all letters in the string specified to lowercase. If there are characters in a string other than letters, it is not affected by this function.
Syntax
To use the LOWER function in SQL Server, we use the following syntax:
LOWER(chuoi)
Parameters :
- string : the string you want to convert, can be a string of characters with text, variables, string expressions or table columns.
Note :
- See UPPER function for reverse conversion.
- LOWER function can be used in later versions of SQL Server: SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, and SQL Server 2005.
For example
Take a look and explore some examples of LOWER functions in SQL Server.
SELECT LOWER('QUANTRIMANG.COM');
Result: 'quantrimang.com'
SELECT LOWER('QuanTriMang.com');
Result: 'quantrimang.com'
SELECT LOWER(' TipsMake.com ');
Result: 'quantrimang.com'
SELECT LOWER('Quan Tri Mang');
Result: 'quan tri mang'
Previous article: LEN function in SQL Server
Next lesson: LTRIM function in SQL Server
Update 25 May 2019
You should read it
- Save time with these text formatting functions in Microsoft Excel
- DAY function in SQL Server
- MIN function in SQL Server
- MAX function in SQL Server
- Don't lower your self-worth by comparing yourself to others!
- ABS function in SQL Server
- SUM function in SQL Server
- RIGHT function in SQL Server
- AVG function in SQL Server
- ROUND function in SQL Server
- DATEPART function in SQL Server
- The specs show that the Samsung Galaxy S9 and S9 Plus duo are lower than the older iPhones
Maybe you are interested
We may be able to see the 'second moon' in the sky with the naked eye next May The most bizarre things people ever bring to space Will the Earth be affected if the comet once destroyed the dinosaurs hitting the Sun? 'Wow!' - Has the mysterious cosmic signal of 'alien' been decoded? True moon, snow moon and comet will appear together today The 7 largest objects people ever launched into space