>>>
>>>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
It works great! Thanks, both of you!
-Michelle