Code has been added to clipboard!

Using Ucase in SQL

Reading time 1 min
Published Aug 9, 2017
Updated Oct 11, 2019

Web Development Course:

SQL UCASE Function: Main Tips

  • This function changes values of a data record to uppercase.

Syntax of UCASE()

SELECT UCASE(col_name) FROM tbl_name;

SQL Server: Syntax

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:

SELECT UCASE(CustomersName) AS Customers
FROM Customer;

SQLite Syntax: Example

SELECT UPPER(Name) AS Customers
FROM Customers;