Replace Text in row of tbl

[Dylan]

I have a table with an 80 char text row that I need to search and replace every occur of a literal with another literal (which is longer in length)

Heres how it looks coming in:

88,wire tfr ref 100 bank of america

I need to replace the "88,wire tfr ref" with "88,SOM WIRE TFR REFER"

*******************************************************
heres how it should look after the update:

88,SOM WIRE TFR REFER 100 bank of america

*******************************************************
Thanks for any help with this ...

 

[mfulton]

It seems like it would be easiest to just create an update query (You are in Access, right?)that replaces the whole text string with the whole new one. If all of the memo/text fields are different except for that little bit, I don't know how to help you, sorry.

Michelle