Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2009
    Posts
    20

    Unanswered: Removing middle initials

    For this query there are many first and last names with some having middle initials with a '.' at the end.

    Current result:
    Hong, Amy L.
    Jackson, Yuri K.
    Nguyen, Roy


    Desired:
    Amy Hong
    Yuri Jackson
    Roy Nguyen

    How can I achieve this with SQL Plus?
    Thanks.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Combine several character functions (both those that return character and number as a result).

    Once you produce a query (which might not be optimal), return back here, provide the code and someone will take a look.

Posting Permissions

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