>The following is not working (must be a brain cramp today). What have I done wrong? ctrlset is the table and reportname is a memo field.
>
>
>select * from ctrlset ORDER BY (PADR(reportname,254))
>
>
>TIA,
>Tracy
VFP accepts either field name or column number in the ORDER BY clause. Try instead
select *, PADR(reportname,254) AS SortField ;
from ctrlset ORDER BY SortField
--sb--