That's right but my question was how would I know whether the particular record has more than one values or not without looping through them?

For example the col3 has more values but col2 has on value. I would like to skip the col2 from going through any loop if it has one value and proceed with the insert statements. If I have more than one values then I have to loop through them for each value to be inserted to the DB. Hope I am clearer this time.