>It's not that exact code I am worried about, but I have a class that updates info on a table from textboxes, and uses the replace command.
>
>But if the class stumbles on a blank code, and attempts to update the table, then it updates everything.
>
>The original code would be:
>
>REPLACE pr_addr1 WITH this.txtPr_Addr1.Value FOR pr_code = lcPr_Code

How about trying the "exact" operator, ==:

REPLACE pr_addr1 WITH this.txtPr_Addr1.Value FOR pr_code == lcPr_Code