>The bit pattern returned represents the columns that were modified. You AND the returned value with a mask that represents the column of interest.
>
>COLUMNS_UDPATED() & 1 = 1 => first column changed
>COLUMNS_UPDATED() & 2 = 2 => second column changed
>COLUMNS_UPDATED() & 4 = 4 => third column changed
>COLUMNS_UPDATED() & 7 > 0 => one or more of columns 1,2, or 3 have changed.
>
>-Mike
Inherited nightmare of non-normalized crap. One table has 52 columns so how do I tie back which one is different in a trigger? That trigger will send a transaction to an Oracle system of the change.
PS great having fun with you @ WilFest.
__Stephen (Head Chef)