>
> Ex: IF (INSERTING OR DELETING) THEN NEW.ID = GEN_ID(G_GENERATOR_1, 1);
>

Paul,

I think she wants to know how to know whether a particular column was
impacted by an update, not whether a trigger is being fired because of
an insert, update or delete.

(By the way, you can't assign a value to NEW.<anything> inside a
delete trigger)

Adam