Received: from proxy.vgs.com (proxy.vgsinc.com [209.48.221.10]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA82858 for ; Mon, 10 May 1999 14:30:23 -0400 (EDT) (envelope-from apendleton@vgsinc.com) Received: from fms28.belvoir.army.mil by proxy.vgs.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.0.1460.8) id KVCVTP73; Mon, 10 May 1999 14:30:17 -0400 Message-ID: <005201be9b0b$ed17ad50$bdd0be80@belvoir.army.mil> From: "Adam H. Pendleton" To: Subject: Trigger question Date: Mon, 10 May 1999 13:38:29 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2014.211 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211 I have a dilema, and I'm not sure what the best way to go about solving it is. I have a table called employee_master, and a table called employee_payroll. The primary key for both tables is the employee name. It would be easy for me to set up a trigger that checked the master table when inserting into the payroll table to make sure the employee exists. My problem is this: The employee names are stored Last, First in both tables. The data file I am parsing to insert into the payroll table contains just the last name. Now I can make a trigger that uses a 'like' and checks the employees division as well to ensure that they are in the employee_master, but how do I update with just the last name? I don't want to insert, I need to be able to update the data in the row. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Si hoc legere scis nimium eruditionis habes.