-
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.
Tomaž
"A common mistake that people make when trying to design something completely
foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams
-
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,',','')
Tomaž
"A common mistake that people make when trying to design something completely
foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|