sql - finding and replacing text in a access table column -

i trying find , replace 'some text' inside access table column new data show below.

this text inside column data

update table set column = replace(column, 'some text', 'new data') 

this not work access databases, there way of performing same action?

it works in vba in sql may need use clause; is, not attempting use replace() if text not found.

update table set column = replace(column, 'some text', 'new data')  column '*some text*' 

i haven't had chance test though.

it might worth putting square brackets around field-name replace([column],, although shouldn't necessary.

added you've discovered, cannot use replace c#. can use other functions - left, right, mid, trim - won't unless simple replace (perhaps left). otherwise, you'll need obtain , loop through updateable recordset , perform replace in c#.

alternatively, if have access database within access, create , save query, , use access-automation run (open) query. obtaining updateable recordset better option.