Larry -

thanks - that is (sort of) what I'm already doing - I was hoping for a simple function along the lines of "If TriggerEvent() = 'Insert'"

>>Hi,
>>
>>Is there any (quick easy) way to tell from within a trigger which event caused the trigger to fire? i.e. - if I have a trigger on update/insert - I would like to know whether it was an insert or an update that caused the trigger to hit
>>
>>TIA!
>
>declare ninsert int, ndelete int
>select ninsert = count(*) from inserted
>select ndelete = count(*) from deleted
>
>if ninsert > 0 /* insert trigger */
>if ndelete > 0 /* delete trigger */
>if ninsert > 0 and ndelete > 0 /* update trigger */
>
>HTH.