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
2497 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

What is a cursor and what is its function?

2 Answers

What is innodb buffer pool?

0 Answers

When DB2 connection fails, will online program work or give errors.

1 Answers Virtusa,

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

0 Answers JPMorgan Chase,

What is rebind in db2?

0 Answers

What is ACQUIRE/RELEASE in BIND?

3 Answers Cognizant,

Mention the location where the output received from explain statement is stored.

0 Answers

how will you retrieve first record in table

1 Answers UST,

What is a db2 collection?

0 Answers

How to design maps