>Sory, Sergey, you're right. I thought maybe Fabio would come up with a one-liner in SQL, so when I saw his message, I did not notice that it was regular Fox code, and not SQL.

Hi Tore,

It can be done with SQL UPDATE in VFP9 but not in VFP8.