The LOWER function converts a string to lowercase.
To convert a string to uppercase use the UPPER function.
This example converts the input string to lowercase.
SELECT LOWER('Los Angeles') AS City
| City |
|---|
| los angeles |
Syntax of the LOWER function.
LOWER(string)
string -- a character expression, variable, or column name.
| CUSTOMER |
|---|
| Id |
| FirstName |
| LastName |
| City |
| Country |
| Phone |
SELECT LOWER(FirstName + ' ' + LastName) AS Name,
City, Country
FROM Customer
| Name | City | Country |
|---|---|---|
| maria anders | Berlin | Germany |
| ana trujillo | México D.F. | Mexico |
| antonio moreno | México D.F. | Mexico |
| tdomas hardy | London | UK |
| christina berglund | Luleå | Sweden |
 |
||
