Removal of special characters

[rkiss]

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

[TomazZ]

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

[rkiss]

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

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


Thanks

Roman

[TomazZ]

oh, yes

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

[rkiss]

Thanks so much

Roman