Follow-up reply...some people will put the line


IF UPDATE(ColumnName)......

in a trigger.



This does NOT check if values changed...it only tells you if the column was referenced in an UPDATE statement. If I say

UPDATE ProductMaster Set Price = Price where ProductKey = 100


The IF UPDATE(ProductMaster.Price) would return a TRUE, which is generally not desirable behavior.