Removal of special characters
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Removal of special characters

  1. #1
    Join Date
    Jun 2003
    Posts
    132

    Removal of special characters

    Hello,

    Does anyone know how to remove specific character based on the wildcard selection.

    I have the first part done:

    ------------------------
    SELECT name
    FROM company
    Where name like '%,%';
    ------------------------

    Thanks for your help

    Roman

  2. #2
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    Probably it's just me - can you be more specific of what you are trying to do.
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

  3. #3
    Join Date
    Jun 2003
    Posts
    132
    I am trying to remove all "," from company names.

    Example: "IBM, Inc." should be updated to "IBM Inc."


    Thanks

    Roman

  4. #4
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    oh, yes
    Code:
    update company
       set name = replace(name,',','')
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

  5. #5
    Join Date
    Jun 2003
    Posts
    132
    Thanks so much

    Roman

Posting Permissions

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


Click Here to Expand Forum to Full Width