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.

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 :

1. string : the string you want to convert, can be a string of characters with text, variables, string expressions or table columns.

Note :

1. See UPPER function for reverse conversion.
2. 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