Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2006
    Posts
    7

    Unanswered: Remove Punctuations

    Hi All,
    I want to remove all the punctuations in an address column if any:

    Select translate(ADDR,' ',':;.,!?-') from Table;

    I am able to remove all except for single quote ('). Can you please suggest a way us Db2- sql

    thanks

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Try this:

    Select translate(ADDR,' ',':;.,!''?-') from Table;

    Andy

Posting Permissions

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