your idea wont give me a and b, but all a,b and d.

you solve this part, then next part will continue.

and this is not homework but work

Thanks Telammica. This is what I have done..

CREATE TRIGGER t_Amendment

ON Amendment

FOR INSERT

AS

DECLARE @stringval varchar(30)

select @stringval = inserted.[Description]

...