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

How many databases can be created inside an instance in db2 ?

0 Answers MCN Solutions,

What is the difference between cursor and select statement?

0 Answers

What is the meaning concurrency in the db2 database?

0 Answers

What does db2 stand for?

0 Answers

Define data page.

0 Answers

What is the SQL Communications Area and what are some of its key fields?

1 Answers

What is copy book?

1 Answers Thomson Reuters,

How to find primary key of a table in db2?

0 Answers

What is cursor stability in db2?

0 Answers

What is cursor?

2 Answers

What is the picture clause of the null indicator variable?

6 Answers

Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......

2 Answers

For more DB2 Interview Questions Click Here