Hi

Following an update trigger I need to manually compare 2 fields in the deleted and inserted tables.

Wat is the syntax I need to use - this is what I want but it is wrong.


'''''
if select ColourRef From deleted where ColourRef = select ColourRef from inserted
'''''

ANy help would be appreciated.

Andy

Select the results into two variables, then check the values of the variables for compatibility.

select @iCR = ColourRef from inserted
select @dCR = ColourRef from deleted

if (@iCR = @dCR)
  -- do what

Brian