>>
>>OK, how about
>>SELECT code, desc FROM codetable INTO CURSOR tmp ORDER BY code;
>>UNION;
>>SELECT PADR('', 4) AS code, PADR("All Codes", 20) FROM codetable INTO CURSOR curYourSource ORDER BY code
>>Note: PADR()s are just to adjust widths to the codetable
>
>Now, that's an interesting variation of Jayesh's idea. Yours doesn't have me creating a dummy table. The question is, would that add one blank, or a blank for each record in the codes table? You don't have to answer that; I'll check it out.
>
>Thanks,
>
>-Michelle
Oh, but it's my pleasure :-)
It will work, you'll see
Regards
Danijel