• I agree Matt. This is what I use in my triggers to see if a change has actually occurred.

    IF EXISTS (SELECT *

    FROM

    INSERTED I JOIN DELETED D ON I.Key = D.Key

    WHERE

    I.Col <> D.Col)