Just for general discussion:

Is there any reason that someone would not SET EXACT ON for the application default?

I can think of specific instances where you just want to match the first X number of characters, but not as a default.

I guess if you get in the habit of doing the ==, it might make sense...

Joe


>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