Thanks Vlad

I have noticed that UPDATE doesn't automatically update, so I decided to use LOCATE and REPLACE to update each row manually, then I can issue TABLEUPDATE for each one.

Thanks
Kev