Thank you for the confirmation.

>>I'm working on my first update trigger.
>>
>>An SP that operates on the column I'm monitoring for update includes this fragment
>>
>>

>>UPDATE dbo.PATIENT_CLAIM_837_2000C
>>SET Claim_Status = '00'
>>WHERE Claim_Seq_No = @iClaimSeqNo 
>>      AND @iClaimPayersCount = @iMatchedPayersCount
>>
>>

>>
>>Is there any reason THAT form is preferable to:
>>

>>IF @iClaimPayersCount = @iMatchedPayersCount
>>    UPDATE dbo.PATIENT_CLAIM_837_2000C
>>    SET Claim_Status = '00'
>>    WHERE Claim_Seq_No = @iClaimSeqNo 
>>      
>>

>>
>>The second form seems more efficient, and it does not fire the trigger if
>>

@iClaimPayersCount <> @iMatchedPayersCount

>>
>
>Yes, second variation is indeed preferrable.