>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