update TB1 a,TB2 b,TBC c
set a. FN,b.FN,d.FN =
ltrim(FN)+isnull(replace(ltrim(s.LN),'0',''),'')
from TBd d
where a.fn=d.fn and b.fn=d.fn and c.fn=d.fn
set a. FN,b.FN,d.FN =
ltrim(FN)+isnull(replace(ltrim(s.LN),'0',''),'')
from TBd d
where a.fn=d.fn and b.fn=d.fn and c.fn=d.fn
如果用触发器的话,怎么写呢?