Hi!
Is not it should be 240? (max length of VFP index key)?
>John,
>
>Add PADR(mymemo, 254) AS sortoder and ORDER BY sortorder to your SELECT.
>
>> How could I ORDER MEMO FIELD in SQL statement? I get error ORDER BY invalid clause error. I tried to include my memo field in my select list, but it still the same. Any ideas?
>>
>>Thank you
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.