>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

Once the data is in the array you could use the ASORT function to order the rows.

or

Use a SELECT .....ORDER BY ... INTO ARRAY to create an ordered array in the first place.