>Hi All:
> I have a view containing numerous rows. One of the fields in my view is called ACCT. Some rows contain NULL value in the ACCT field. I need to know how to replace the NULL value with the previous row's value in the ACCT field in a reslut set of my view?
>
>I.E
>ACCT Order
>---- -----
>123 Shoes
>876 Shirts
>NULL Thread
>
>I need to replace Null with 876.
>
>Thanks for all of your help!!
I don't think, it's possible in SQL statement. You can write an SP to make updates...
If it's not broken, fix it until it is.
My Blog