Trued to write a trigger for this table basing it on the example you posted .Where am l going wrong ?

CREATE TABLE [TranTypes_New] (

[TranCode] [char] (3) COLLATE Latin1_General_CI_AS NULL ,

[TranType]...