I am having n number of records in a table which consists of emp-name is one of

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.

Question Posted / sudheern

1 Answers
2538 Views
Cap Gemini, I also Faced
E-Mail Answers

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

why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2

3 Answers

how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE

10 Answers IBM,

What is query for your birthday date should be in hours,minute and seconds format?

1 Answers Fidelity,

i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

3 Answers UST,

What is DCLGEN ?

2 Answers

How to restart a DB2 program?

0 Answers Cognizant,

How to find the maximum value in a column in the db2 database?

0 Answers

Bind concepts in DB2 cobol

10 Answers IBM, TCS, TRD, Virtusa,

What is Declaration Generator(DCLGEN)?

1 Answers

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?