I need to know if a field was updated in an update statement, even if it
was updated to the same value that it already contained.
Basically, I want the field to be automatically set to null if the
update statement didn't manually set it to something.
I could not figure out how to do this with a trigger or rules, as if the
value was populated before the update statement, it will be in both the
new and the old structures.
My only thought is to have a trigger change the value that is updated
and then if it is the same value in the new and the old then I know that
it was not updated, but that is uglier then I would like.
Any thoughts?