>>>
>>>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.

For sure. Thanks.