Doesn't an instead of trigger run instead of the sql that initially triggered the trigger in the first place. So if I just changed my above trigger to an instead of trigger then no updates at all would happen on the notes field, as I would be running the sql in my trigger instead.
Or am I confused.