repartial text

[comeng]

Hi
Looking for help with partial text replacement

I get various tables with Forenames in them some of which are shortened ie Elizh for Elizabeth, using an update query i can obviously convert all the Elizh's to Elizabeth but when the Elizh appear as the second or third name I am stumped ie Ann Elizh Mary.
would welcome any suggestions of ways of dealing with this

 

[Matt Greatorex]

You can use the Replace() function to replace any occurrence with the full "Elizabeth".

e.g.

Loop through table
For each record, Replace(name,"Elizh","Elizabeth")
End loop

If Elizh is anywhere, it gets replaced. f it doesn't exist in a record, nothing happens.

 

[comeng]

thanks matt

nearly got that but replace function keeps coming back with a compile error
"Expected =" will keep looking to see what I am doing wrong.

Incidentally using Access 2000
Phil

 

[comeng]

ok found that will get back to you