Thanks. I will check the indexes and the order of the fields.

quote:

---

All the code has to be wrapped in an Execute or sp_executesql string input. You cannot substitute a table with a variable.

Thanks...

You will need to do something like this:

declare @iVar1 varchar

declare @oVar1 varchar

--Populate the vars (aliasing is necessary)

select @iVar1 = i.Var1 from inserted i

select @oVar1 = d.Var1 from deleted d

--Check if...

Thanks for bringing out this article. This has set me thinking - we are about to finish an app (SQL being the RDBMS) and now this has set us thinking!!

...

Thanks a lot folks.

Thanks a million folks!

Madhu