>I customer want to order by a MEMO field in a SQL query.
>
>I noticed it doesn't work.
>
>Is there any workarounds?
>
>I tried substr() ect..
>
>i.e.
>select textfield,memofield from mytable order by memofield;

Try

SELECT textfield,memofield, LEFT(memofield,254) AS memosort ;
    ORDER BY memosort