Hello Sergey,
Thank you for doing that. Haven't had a chance to really look at your code yet. But following that with:
select * from crsResult order by itemNum
Almost gets the exact result I need...I just need to lose the case where there is status code of 1 and no 3's to go with it.
I must work with it more to guarantee that the above SELECT will always return them in the right order (NULLs for each column at the bottom of the group).
Thanks! :)
>Hi Steve,
>
>Here's the first draft.
SET TALK OFF
>CREATE CURSOR test ( ;
> ItemNum C(5), Status C(1), Cust C(3), Sku C(10))
>SET TEXTMERGE ON
>SET TEXTMERGE TO ("test.txt")
>
SNIP
>
Steve Gibson