Re: How do I do this in SQL??

John Gose wrote: > > I want to create an insert trigger. The trigger needs to test for NULL > in one of the fields of the record to be inserted. If the field is > NULL, I want to set the value of the field equal to the value of another > field in the same record. You can't do this because an insert trigger cannot update the triggering table. However, you can call Informix and ask them to add your name to the list of those wanting this capability. Give them feature request number 2566. Cross your fingers but don't hold your breath - this request was submitted 9/2/93. ----------- Roger Tomas AG Communication Systems