Software Testing

k2G9Eo9
RdZQRt6

Popular Posts

U-CASE


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_idNameSurnameSalaryDept_id
1rajeshKhanna450002
2snehaGupta550004
3sandeepNehte950001
4kirtiPatil250003
5nileshJadhav450003
6dipeshDas350005
7kailashRane620001
8kavitaDeshpande480003
9sanjayDatt500003
10shrutiHasan780001

Syntax For SQL:
SELECT Emp_id,UCASE(Name),Surname, salary,Dept_id FROM Employee
After Execute: 
Emp_idNameSurnameSalaryDept_id
1RajeshKhanna450002
2SnehaGupta550004
3SandeepNehte950001
4KirtiPatil250003
5NileshJadhav450003
6DipeshDas350005
7KailashRane620001
8KavitaDeshpande480003
9SanjayDatt500003
10ShrutiHasan780001

No comments:

Post a Comment