The UPPER function converts a string to uppercase.
To convert a string to lowercase use the LOWER function.
This example converts the input string to uppercase.
SELECT UPPER('Los Angeles') AS City
| City |
|---|
| LOS ANGELES |
Syntax of the UPPER function.
UPPER(string)
string -- a character expression, variable, or column name to convert.
| CUSTOMER |
|---|
| Id |
| FirstName |
| LastName |
| City |
| Country |
| Phone |
SELECT UPPER(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 |
 |
||
