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