Quotation mark syntax

benkingery

Registered User.
Local time
Yesterday, 17:26
Joined
Jul 15, 2008
Messages
153
I have a field that I need to perform and update statement to. I need to replace any instance of quotation marks (") with double quotation marks (""). For this I know I need the replace function, but I'm not clear on the quotation mark portion of the syntax.

Here's what I have:

Code:
Replace([EB_Description],"'"'","'""'")

Any thoughts?
 
You could use

Replace([EB_Description], Chr(34), Chr(34) & Chr(34))
 
Last edited:
You did it! Thanks.
 

Users who are viewing this thread

Back
Top Bottom