Update Query Question

[Guest]

Hello all,

Can anyone tell me how to use the Instr() function to change all occurances
of the word "Trm" to the word "Term" using an update query.

-Sky

 

[Duane Hookom]

I'm not sure why you want to use Instr() and a query. If this is a one time
task, open the table in datasheet and use the Edit menu to find and replace.

You might be able to use the Replace() function in an update query.