>>
>>What is your SELECT statement? Anyway, you should do it like:
>>
>>select memofield, padr(memofield,200) from ... order by 2
>
>Yuri/Sergey:
>Thanks for your responses, this works fine except that this change is for a generic Query Builder for reports that is fed from a meta data table and I would need to change the whole structure of the builder to work with sorting expressions on the memo field. I am thinking now that the best solution for me is what Tore suggested. Thanks all.
Remember to rename the new field to the same name as your old memo field, after the conversion is done.