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

Kev