UPDATE t1SET t1.Col2 = (select top 1 x.col2 from table1 as x where x.col1 < t1.col1 and x.col2 is not null order by x.col1 desc)FROM Table1 AS t1WHERE t1.Col2 IS NULL --------I add this one just to update only null values..

UPDATE t1SET t1.Col2 = (select top 1 x.col2 from table1 as x where x.col1 < t1.col1 and x.col2 is not null order by x.col1 desc)FROM Table1 AS t1WHERE t1.Col2 IS NULL --------I add this one just to update only null values..

Thanks Peso & visakh16 for all your efforts to solve my problem...you make my job easily....Thanks to both of you.....as for the code that you gave it to me..ill just add the WHILE loop to find any null values....and then its done!!!!!...and solve my problem!!!