>I am trying to create an instead of trigger that builds a unique key based on other items inserted into the table. My trigger works fine if I put any bogus/temp value into the unique key field, but gives a: 'Column can not be null.' error if I try to enter the data without anything in the field.
>
>Is there a way around this, or do I always need to insert a temp value to satisfy the key field entry?

Rollin,

I haven't tried it, but will specifying a column default work in this case?