I have a select statement that is failing whenever my 'order by' is a memo field. It returns the error "SQL: ORDER BY clause is invalid."

I have a custom grid cass that orders the column when the header is clicked on. It works great, except if the columns recordsource is a memo field.

Following is the code that is failing:

select *;
From (cAlias);
ORDER BY &lcOrder;
into cursor (lcResultTable) readwrite

In this particular case lcOrder='FDESC ASC'
wher FDESC is a memo field on a job description.

If FDESC were anything but a memo field, it would work fine.

Do I have a viable alternative, or is it just not possible.