Thanks for your efforts Sergey. I think I will do this as a VFP solution for now.

>Hi James,
>
>I spend some time on this and came to conclusion that it cannot be done with a query in SQL 2000.
>
>>Thanks Sergey. I know how to do this with a cursor I just try and avoid them when I can. I may do this with VFP also since the result set will not be that much different in size either way.
>>
>>Thanks again for your help.