>>>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.
>
>I was sure that I said that! ;-)
>
>Does Guinness qualify as Dark Beer? If so, more power to your elbow!
Whoops, sorry Mark. I read you post using the UT navigator and missed the part about the SQL - SELECT. It was probably below the readable area and I neglected to scroll down. (At least that's my story and I'm sticking to it.< g >)
George
Ubi caritas et amor, deus ibi est