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