Steve,

You can grab a portion of the memo field, using the left() function, see example below:

>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."
>
>Following is the code that is failing:
>

>select *, left(fdesc,10) as shortDescription ;
>From (cAlias);
>ORDER BY shortDescription;	
>into cursor (lcResultTable) readwrite

>