Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2011
    Posts
    45

    Unanswered: Change cases in db2

    Dear All,
    We are having a character field in a table having values like HARSH VERMA,
    and we have to change it to Harsh Verma..

    db2 version is 9.7...
    Can any one share some helpful thoughts..


    Regards,
    Harsh

  2. #2
    Join Date
    May 2009
    Posts
    508
    Provided Answers: 1
    harsh.v, you might look into the INITCAP function. It should do what you want. However, it would have a problem with names like McCoy. Only the first character would be upper case as Mccoy.

  3. #3
    Join Date
    Aug 2011
    Posts
    45
    Thanks a ton...it worked

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •