Published on: 27 September, 2013

SQL UCASE()

Tumblr Digg Google Plus

Example Customer Table

The following data table is for example only. Let's use UCASE() function to convert the customer name to all upper case characters. The column we going to use is the Name column.

ID Name Age
1 Thomas Anderson 45
2 Andrew Golden 38
3 Ken Tom 30
4 Andrew Golden 36
5 Timonthy Kirk 32
6 Kelly Smith 39

Example of Running SQL Query

SELECT ID, UCASE(Name) AS Name, Age
FROM   Customers

After running the above query, it will return the following result.

ID Name Age
1 THOMAS ANDERSON 45
2 ANDREW GOLDEN 38
3 KEN TOM 30
4 ANDREW GOLDEN 36
5 TIMOTHY KIRK 32
6 KELLY SMITH 39

Comments

There are no comments available.

Write Comment
0 characters entered. Maximum characters allowed are 1000 characters.