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.
Answer Posted / chandra
Use INITCAP() Function
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
List down the data types in the db2 database.
How do I optimize a query in db2?
What is the usage of open cursor command?
Are view updateable?
Is db2 free?
What is the use of commit in db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
How to fetch the last row from the table in SQL (db2)?
What action db2 takes when a program aborts in the middle of a transaction?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is netezza database?
What is check constraint in db2?
What is universal database?
How is a typical db2 batch pgm executed?
How to view db2 table structure?