Hello Ger;

Some suggestions:

1. From the command window open the table and do the replace and check the relsult.

Could you have more than one dbc/table and it is now updating the correct one?

2. Post your code. We might have a better clue what is going on.

3. If all else fails I will join you in a pint or two (more if necessary) of Guinness! :)

Tom

>Hi All,
>
>
>I want to update a field in a table with the following.
>
>SELECT mytable
>REPLACE mytable.myfield WITH "YES"
>
>myfield CHAR 3
>
>It just wont update for me.This is probably something silly but I cant find anything wrong.
>
>
>Anyone?