The UCASE() Function convert the value of the field to Uppercase.
The basic syntax is as follows:
SELECT UCASE(Column_Name) FROM Table_Name |
Employee | ||||
Emp_id | Name | Surname | Salary | Dept_id |
1 | rajesh | Khanna | 45000 | 2 |
2 | sneha | Gupta | 55000 | 4 |
3 | sandeep | Nehte | 95000 | 1 |
4 | kirti | Patil | 25000 | 3 |
5 | nilesh | Jadhav | 45000 | 3 |
6 | dipesh | Das | 35000 | 5 |
7 | kailash | Rane | 62000 | 1 |
8 | kavita | Deshpande | 48000 | 3 |
9 | sanjay | Datt | 50000 | 3 |
10 | shruti | Hasan | 78000 | 1 |
Syntax For SQL:
SELECT Emp_id,UCASE(Name),Surname, salary,Dept_id FROM Employee |
After Execute:
Emp_id | Name | Surname | Salary | Dept_id |
1 | Rajesh | Khanna | 45000 | 2 |
2 | Sneha | Gupta | 55000 | 4 |
3 | Sandeep | Nehte | 95000 | 1 |
4 | Kirti | Patil | 25000 | 3 |
5 | Nilesh | Jadhav | 45000 | 3 |
6 | Dipesh | Das | 35000 | 5 |
7 | Kailash | Rane | 62000 | 1 |
8 | Kavita | Deshpande | 48000 | 3 |
9 | Sanjay | Datt | 50000 | 3 |
10 | Shruti | Hasan | 78000 | 1 |
No comments:
Post a Comment