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

You've exceeded the maximum key length for an index expression - the key expression is limited to 240 bytes. Try changing the ORDER BY to (PADR(reportname,240))

Sorry about the error in the original