From: esquel@sommarskog.se   
      
   Gene Wirchenko (genew@ocis.net) writes:   
   >      Why would this be relevant since the trigger is for after the   
   > insertion?  Assuming the above is correct, I think that I am missing a   
   > nuance.   
      
   CREATE TRIGGER tri ON tbl AFTER INSERT, UPDATE AS   
      
   Notice the word UPDATE?   
      
   True, I don't know whether Johnnyb wants to handle updates. He only   
   says "when particular text shows up in a particular column". Really what   
   mean I don't know.   
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Books Online for SQL Server 2005 at   
   http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx   
   Books Online for SQL Server 2000 at   
   http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)