>Hello friends, REPLACE or UPDATE. Which one should I use? Why?

In addition to the difference about the record pointer, the two have different locking behavior. REPLACE locks the whole table, but UPDATE uses record locks.

Tamar