Thursday, March 29, 2012

How remove all quote characters in a sql table?

Hi

I have a table with a few hundred emailadresses. How can I delete all quotes (') from the addresses, so that'email@.email.com' is replaced asemail@.email.com.

Thank you

zipfeli

You can use the REPLACE Function. And you want to an UPDATE not a DELETE.

UPDATE table SET Column =REPLACE(column, '''', '')

|||

UPDATE TableName SET EMailAddrCol = REPLACE(EMailAddrCol, '''', '')

I hope this helps,

Best of Luck!

No comments:

Post a Comment