scope of my work is
my select statement is having null value in a column as shown below,
1 first
2 NULL
3 2nd
4 NULL
5 NULL
6 NULL

what i want if there is any null value found previous column will be placed to current row... the result of my query should be like this

1 first
2 first
3 2nd
4 2nd
5 2nd
6 2nd


what i was thinking to use a udf function where I can place value in Context_Info, if there is value found in row calling the function and set this value in Context_Info otherwise null value found set the column data from Context_Info.

Unfortunately, udf can't change the state out of the world...
help out plz..