I understand John, thanks for the info

Karl, that's obsolutely brilliant, exactly what I needed many thanks !

That's great, thanks, even if I don't use the example you supplied it's great to learn from. Thanks again

I'm not sure that splitting it into 2 tables would help, the senario I'm using it in is at work there are 96 different towns or regions that we as...

Many thanks Karl, I did suspect using a cursor would be one solution, the temporary table idea wasn't something I thought of and looks like this might do more or...

Thanks Karl, the only problem I have is there are 96 fields at the moment and that could change to more at a later date, your solution, is that the...

many thanks

Thanks everyone for the examples. I appreciate your time

that's great, thanks

many thanks Ramesh and Paul

That's brilliant, thanks Matt

thanks Andras, I was wondering if I need to use some kind of loop within my Store Procedure to do the inserts?

many thanks, I'll give it a try. And thanks for getting back to me so quick

so could I not put a id field in and do something like select top from feild2 where field2 is not null order by id?

as an example as to what I'm after

First Last id

======================

John Brown ...