>>value of lcstrsql
>>
>>SELECT * from prodct
>>ORDER BY date_purch ASCENDING
>>INTO CURSOR mnprodct1 nofilter
>>update:
>>with code to take out CRLF
>>
>>SELECT * from prodct ORDER BY date_purch ASCENDING INTO CURSOR mnprodct1 nofilter
>
>The last one shoud work, does it?

Mostly, I had to change ASCENDING to ASC. :) full word only works with indexes, not order.