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.
--sb--