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;
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.