Hi, Suppose: create table rawrecords ( myrec text; ); create table cookedrecords ( id varchar(10) not null, name varchar(20) not null, value integer not null ); We insert a record say string: "thisid/thisname/12345" into the rawrecords table. I would like to have a trigger on that table that splits the raw record into: thisid thisname 12345 and inserts those in the cookedrecords table. It's easy to split such a string using a perl function but how to get them in the table then ? Seperate functions to get each attribute ? seems quite expensive ! Am I overlooking some posibilities here ? Thanks, Feite Brekeveld ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])