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

Probably it's just me - can you be more specific of what you are trying to do.

I am trying to remove all "," from company names.

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


Thanks

Roman

oh, yes

Code:

---

update company
  set name = replace(name,',','')

---

Thanks so much

Roman