OK, here's what I'm trying to do:

When a new order line is added or qty_ordered is changed, copy qty_ordered to qty_to_ship and put an * in UDF_4

Only for 'O' type...

Thanks, I ended up using this:

IF OBJECT_ID('table02')  IS NOT NULL TRUNCATE TABLE table2