>Hi all,
>
>In one of my applications I copy fields (mainly names & addresses) from a table into an array. I'd then like to sort the array by surname (field name is S_NAME) - does any know whether I can do this without re-indexing the table by S_NAME first? I can't re-index the table becasue it's a shared table....
>
>Regards
>
>
>Chris Kable
>MotorLink Systems
Hi Chris,

In addition to using ASORT() as Mark mentioned, you can create the array by using an SQL - Select statement. Simply order it by the S_NAME field.