Edit/Replace [square bracket problem]

[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

 

[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]]*"));

 

[David Lloyd]

David:

You may find the following article useful.

http://office.microsoft.com/en-us/assistance/HA011715361033.aspx

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


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