Contents
SQL UCASE Function: Main Tips
- This function changes values of a data record to uppercase.
Syntax of UCASE()
Example
SELECT UCASE(col_name) FROM tbl_name;SQL Server: Syntax
Example
SELECT UPPER(col_name) FROM tbl_name;Demo Database
Below there is a piece of "Customers" table:
| ID | Name | Contact | Address | City | Postal_Code | Country |
|---|---|---|---|---|---|---|
| 1 | Ben Choplinks | Ben Choplink | Obeesre Str. 51 | Rome | 11207 | Italy |
| 2 | Donald Rich | Donald Richario | Avda. de la Confgfstitución 4122 | Tallin | 17021 | Estonia |
| 3 | Lilly Smilkins | Lilly Smilkin | Matadsderos 2312 | Eguero | 14023 | Mexico |
| 4 | Brandinina | Tom Hitchins | 110 Hanegover Sq. | London | WB2 2DP | UK |
| 5 | Carizmos | Christiano Kerrys | Berguvsesvägen 9 | Luleå | S-968 43 | Sweden |
SQL UCASE(): Example
In the code example below we take "Name" and "City". Finally, we change the "Name" column to uppercase:
Example
SELECT UCASE(CustomersName) AS Customers
FROM Customer;