Vince,

I did not get the previous messages so I don't know exactly what you're trying to do, but here's what I know.

In the UPDATE trigger, you have access to "logical" tables called inserted and deleted. The inserted table contains new values and the deleted table contains the old values. Look for CREATE TRIGGER in books online.

Also, don't forget that when the trigger runs, it might run on more than one record, so don't assume that the inserted and deleted table contains a single record each.

HTH

---

>Daniel,
>Our understanding is that the update trigger is fired after the row is updated and the trigger is processed using the updated values. We are trying to get at the old values in the record prior to the update. We need to do some comparison of the previous value with the updated value.
>Any thoughts on how to get at the old value would be greatly appreciated.