Hi Alistair
The combination of the functions Mid$(), Len() and Instr() will help
solve your problem.
For example given
Mytxt = "2105 ALBANY CREEK"
the statement
Mid$( Mytxt , Instr(1, Mytxt , " ") +1, Len(Mytxt))
will return
"ALBANY CREEK".
Instr(1, Mytxt , " ") returns the position of " " in Mytxt starting
with the 1st character.
Len(Mytxt) returns the number of characters in Mytxt.
Mid$( Mytxt , Instr(1, Mytxt , " ") +1, Len(Mytxt)) returns the range
of characters defined by the other 2 functions.
The following statement will then replace the contents of the table.
Update Mytable Set MyCol = mid$( MyCol, instr(1, MyCol, " ")+1,
len(MyCol))
Ian
