SQL statement to remove quote marks?

KennyRohan · Aug 17, 2006

Does anyone have an SQL routine to use in MS Access to remove unwanted quote marks from the email address field in all records? Thank you.

webturner · Aug 18, 2006

To replace single quotes in ms-access:

Code:

UPDATE tblEmails SET strEmail = Replace(strEmail, "'", "")

To replace double quotes in ms-access:

Code:

UPDATE tblEmails SET strEmail = Replace(strEmail, """", "")

To replace single quotes in SQL-Server:

Code:

UPDATE tblEmails SET strEmail = Replace(strEmail, '''', '')

To replace double quotes in SQL-Server:

Code:

UPDATE tblEmails SET strEmail = Replace(strEmail, '"', '')