My requirement is to split a string for example am taking one row from from a string column which is in this form (1000:34.0:1101:45.0:1231:56.0) where 1000, 1101 1nd 1231 are my id's and 34.0, 45.0 and 56.0 are the costs. I want to split this string and insert into an id and a cost column in a separate table. Can anyone Please help me out with the script??