Trigger Help

I want to write a trigger that will update non-primary key fields in a table on an insert. For example, I have a table called CUST that has two fields, ID and NAME. The ID field is the primary key. The CUST table might look like:

ID     NAME
1     Scooby Doo
2     Scrappy Doo
3     Shaggy

When I issue "insert into CUST values (1,'Freddy'); I want the table to look like:

ID     NAME
1     Freddy
2     Scrappy Doo
3     Shaggy

Any suggestions? Received on Fri Dec 11 1998 - 00:00:00 CST