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 |