I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.



I am having n number of records in a table which consists of emp-name is one of the field among them..

Answer / chandra

Use INITCAP() Function

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is the use of COMMAREA ?Minimum how much data we can pass from it?

7 Answers   Cap Gemini,


If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

4 Answers   ADP,


What are the various locks available?

5 Answers   CTS,


what is a corelated subquerry?

0 Answers   IBM,


In which column of which DB2 catalog would you find the length of the rows for all tables?

2 Answers  






pls tell me abt the normalization five types....

2 Answers  


What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.

4 Answers   Cap Gemini, Verizon,


what is consistency token

3 Answers  


what's the best lock size that you could use when you create a tablespace?

2 Answers   IBM,


what is a collection?

2 Answers  


What is difference between rollback and commit?

0 Answers  


What is the usage of open cursor command?

0 Answers  


Categories