about 7 years ago
This function is used to convert value of column in uppercase . If value of column already in a uppercase then it doesn't covert . It convert only if value of filed is in lowercase .
select ucase ( column_name ) from table_name ;
Syntax for SQL :
select upper ( column_name ) from table_name ;
Table name : Employee_Info
Id Employee_name Employee_Age Employee _Salary
1 Mukesh 23 100000
2 Ayush 24 200000
3 Ishan 20 400000
4 Pranav 35 700000
5 Abhishek 26 800000
6 Ravi 25 300000
7 David 40 800000
Query to convert column value in uppercase .
select ucase ( Employee_name ) from Employee_Info ;
Starting with Chrome version 45, NPAPI is no longer supported for Google Chrome. For more information, see Chrome and NPAPI (blog.chromium.org).
Firefox and Microsoft Internet Explorer are recommended browsers for websites using java applets.
Chrome Version Support
Are you sure, you want to delete this comment?
Terms of Service
| © copyright 2022 FindNerd.com. All rights reserved.
Sign up using