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