>>Hi all:
>> How can I find the HIGHEST or MAX value within a set of records?
>>
>>Take this for example:
>>
>>CodeNo LevelNo
>>1 1
>>1 2
>>2 1
>>1 1
>>1 3 *
>>2 1
>>2 3
>>
>>How do I locate the maximum value (3) of all CodeNo=1?
>
SELECT MAX(LevelNo) AS MaxLevelNo FROM MyTable
WHERE CodeNo = 1 ;
INTO CURSOR
whatever>
>>In this example record no 5.
>>Thanks in advance
>>Ulises