>Hi Experts,
>
>Is it possible to obtain one's ranking without the need to maintain a rank field?
>
>For example, if we have a Grades table:
>
>Student GenAve
>Marc 98%
>Steve 89%
>Jeff 90%
>Adrian 92%
>Dennis 80%
>
>I would then like to do a:
>
>

>SELECT Student, GenAve, SomeRankFunction() as Rank FROM Grades ORDER BY Rank
>

>
>I guess the above should be MySQL syntax since my backend is MySQL.

If you're pulling those data into a VFP cursor, the record number can be used as the rank:

SELECT ;
  Student ;
  , GenAve ;
  FROM Grades ;
  ORDER BY GenAve DESC

* then, in your VFP cursor RECNO() gives the rank