IF UPDATE

IF UPDATE (ColumnName)

Uses in Triggers: return True if the column was updated.

Note: An update means that the query has SET the value of the column:

UPDATE TableName SET ColumnName = ColumnName --> UPDATE (ColumnName)=TRUE

UPDATE TableName SET ColumnName = 10 --when ColumnName already =10 --> UPDATE (ColumnName)=TRUE