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

>