I am working with an Access 97 database file that contains a memo field that has some invalid HTML tags that need to be cleaned up. For example, it contains "<\I>" as the closing tag for italics instead of "</I>". Oracle supports a "Replace" function that would let me do this update by running a SQL query.
UPDATE tablename
SET textfield = REPLACE(textfield,"<\I>","</I>"
where INSTR(textfield,"<\I>">0;
I don't find an equivalent for the REPLACE function in MS Access. What would be the best way to automatically handle a series of edits like this in Access?
UPDATE tablename
SET textfield = REPLACE(textfield,"<\I>","</I>"
where INSTR(textfield,"<\I>"
>0;I don't find an equivalent for the REPLACE function in MS Access. What would be the best way to automatically handle a series of edits like this in Access?
