>
>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
--sb--