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.
- 1 Answers
- 1749 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / chandra
Use INITCAP() Function
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do I copy a table in db2?
What is table space in db2?
What is null in db2?
How do you concatenate the firstname and lastname from emp table to give a complete name?
Describe major components of db2?
can all users have the privilage to use the sql statement select * (dml)?
How to access db2 tables in mainframe?
How do you stop a db2 database in linux?
What is ibm db2 database?
Can there be more than one cursor open for any program?
What are the full forms of spufi and dclgen and why are they used?
List down the types of triggers in the db2 database?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is phantom read in db2?
How do I import a csv file into db2?
