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

What is dbrm?

1179


run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4372


What is the use of with ur in db2?

1108


Which command is used to connect to a database in DB2 ? Give the Syntax.

1150


What is access path in db2?

1042


What is bufferpool in db2?

1097


What is the role of data manager in the db2 database?

1158


What is the use of db2 optimizer?

1175


What is ibm db2 database?

1067


What is the default page size of buffer pools?

1171


If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1222


What are the various data types available in db2?

1145


What is db2 command?

1091


What is the latest version of ibm db2?

1338


What is bind in db2?

1096