UPPER() function converts the string into all uppercase characters. We can use this function to maintain the data integrity of text columns in the tables.
Example:
Suppose we have a table ‘tbl_employee’
Table name: tbl_Employee
| Employee Id | EmpName | Salary | Department |
| 1 | Ankur | 1200 | Sales |
| 2 | David | 3400 | Sales |
| 3 | John | 1500 | HR |
| 4 | James | 1200 | Production |
| 5 | Mohan | 4500 | Production |
| 6 | Ram | 2300 | HR |
See the following sql query and its output
SELECT UPPER(EmpName), Department FROM tbl_Employee
And output will look like this:
| EmpName | Department |
| ANKUR | Sales |
| DAVID | Sales |
| JOHN | HR |
| JAMES | Production |
| MOHAN | Production |
| RAM | HR |