UPDATE triggers with REPLACE statements

[Jim McNeely]

Here is a fun one!

I have a set of tables that get populated and changed a lot from lots of REPLACE
statements. Now, I need an ON UPDATE trigger, but of course the trigger never gets
triggered because REPLACES are all deletes and inserts.

The trigger is going to populate another table as a queue for a system to do something
whenever a particular field changes.

SO, does anyone have some slick idea how to handle this little dilemma? I have an idea but
I have a feeling there is something better out there.

Thanks!

Jim McNeely