Edit/Replace [square bracket problem]

D

David Kennedy

Hi,

Is there anyway to do an edit and replace of chars including square
brackets.
I want to replace [MM] with mm.

Thanks in advance,
David K
 
B

Brendan Reynolds

You can do it with an update query and the Replace() function, and square
brackets are not an issue in this scenario ...

UPDATE tblTest SET tblTest.TestText = Replace([TestText],"[MM]","mm");

In other scenarios, where square brackets are a problem, just double them up
....

SELECT tblTest.TestText
FROM tblTest
WHERE (((tblTest.TestText) Like "*[[MM]]*"));
 
Top