Update Query to search for " and replace with something else

[Bingo]

I am using Like to search for certain text and Replace to replace it with
some other text. Example:
Like "*(*" Or Like "*)*"
Replace(Replace([Data]!CODE,"(","["),")","]")

However, the character I would like to search for is the quotation mark "
and this does not work.

Any suggestions? Thanks in advance.

 

[Dennis]

Just use Chr(34) which is the ASCII character for a quitation mark