Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    1

    Unanswered: db2 query with case translation

    Hi,
    I have a select query like this ,
    select enam from emp

    Now I want to modify the query such that only the first letter of ename I query must be upper case and the rest in smaller case.
    Thanks in advance.

  2. #2
    Join Date
    Nov 2003
    Location
    Germany
    Posts
    62
    Try

    select upper(substr(enam, 1, 1))!!lower(substr(enam, 2, length(enam)-1)) from emp

Posting Permissions

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