>I ran the following command on a table called PROPERTY:
>
>replace pr_addr1 with "" for pr_code = ""
>
>and it replaced every single record's pr_addr1 with a blank and there were no pr_codes = to "".
>
>Surely this is not correct.
>
>Please advise.
>Thanks
>Kev

Not a bug. When do string comparisons, VFP matches up to the length of the string on the righthand side. As Bruce and Mike suggested, there are things you can do:

- Use ==, which is "exactly equals"
- SET EXACT ON
- Use EMPTY()