I have a database table with fields in SQL7. One of the fields is the auto generated id field. How can I look at another field (call it id2) and if id2 is NULL, I want to make it the same value as the id field..? Would I use a Stored Procedure? function? or what? I need this to happen automatically or on a periodic timeframe.