Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!eternal-september.org!feeder.eternal-september.org!goblin1!goblin.stu.neva.ru!nrc-news.nrc.ca!border3.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!nntp.giganews.com!npeer01.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
From: Johnnyb <john.lutheran@gmail.com>
Newsgroups: comp.databases.ms-sqlserver
Subject: Trigger help
Date: Thu, 29 Mar 2012 05:47:26 -0700 (PDT)
Organization: http://groups.google.com
Lines: 1
Message-ID: <11931752.1474.1333025246004.JavaMail.geo-discussion-forums@pbjv6>
NNTP-Posting-Host: 198.102.153.2
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1333025372 13286 127.0.0.1 (29 Mar 2012 12:49:32 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 29 Mar 2012 12:49:32 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=198.102.153.2; posting-account=kYW--QoAAABRuO6dTOz2QITtLsB-PRVZ
User-Agent: G2/1.0
X-Received-Bytes: 1101
Xref: csiph.com comp.databases.ms-sqlserver:944

I need to create a trigger that will fire when particular text shows up in a particular column. Then I need to copy that row to another table. Not sure how to do this. Any help would be greatly appreciated.