>I understood that part. My I need a help getting started is a good method of detecting when an update has not occurred. Since the code use the replace command how do I test if the update failed? (I do not have manuals and help files are not exactly clear on this topic).

That's what testing the return from TABLEUPDATE() is for.