>>Hello friends, REPLACE or UPDATE. Which one should I use? Why?
>
>What is the exact intention and what do you want to do? I think both should work fine but REPLACE command moves record pointer and UPDATE doesn't.
IMHO both may or may not move he pointer. The real difference is record locking behavior (as Tamar explained).