Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

List down the data types in the db2 database.

1097


How do I optimize a query in db2?

1081


What is the usage of open cursor command?

1084


Are view updateable?

1020


Is db2 free?

1077


What is the use of commit in db2?

1060


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2906


How to fetch the last row from the table in SQL (db2)?

1632


What action db2 takes when a program aborts in the middle of a transaction?

1132


Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1052


What is netezza database?

1001


What is check constraint in db2?

1062


What is universal database?

1055


How is a typical db2 batch pgm executed?

1159


How to view db2 table structure?

1002