Replace (or insert or replace) could come in handy in scripts to
update a database or in replication. I've have never used them
myself (being a Firebird user), however have seen numerous places
where they would be a useful shortcut.

Even though it would be useful, its not high on my personal wish
list.

Regards
Ian Newby