Hi Garrett,

Thanks for the reply, but how if my table is in fox2x format? I tried your suggestion but it still come out with the first match record..

Please help! thanks a lot!


>>hi all,
>>
>>I have this query:
>>

>>Select a, b, c from MyTable;
>>  into array MyArray;
>>  where a=MyKey
>>

>>
>>If there are serveral matches in the table, how should I modify this query in
>>order to get the last matched one?
>
>One way to do this would be to use the TOP 1 and the ORDER BY myField DESCENDING clauses.