Hi!

If it is VFP query, try:

Select padr(MemoField,200) as MyMemoField, ... From ... ORDER BY 1

This way query will return a character field with length 200. ORDER BY 1 tells to order by the first column of the result set.

You can probably do something similar on SQL Server, if query you do runs there.

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