>
>Thanks Yuri. This is OK but I am having a problem using the index in an SQL SELECT. I am getting an 'ORDER BY clause is invalid.' error.

You have to add calculated field to the query result to sort on it.

SELECT *, PADR(mymemo,75) AS SortOrd ;
  FROM mytable ;
  ORDER BY ..., SortOrd