John,
Add PADR(mymemo, 254) AS sortoder and ORDER BY sortorder to your SELECT.
> How could I ORDER MEMO FIELD in SQL statement? I get error ORDER BY invalid clause error. I tried to include my memo field in my select list, but it still the same. Any ideas?
>
>Thank you
--sb--