Anyone know how to return the position of a record in a table?

Anyone know how to return the position of a record in a table? I'm
building a highscore list and I want to be able to say what position a
player is without having to check all the other players.
Cheers,
Ciarán

You could query the count of anything that is more than that player's
score, I guess.

Ciaran wrote:
> Anyone know how to return the position of a record in a table? I'm
> building a highscore list and I want to be able to say what position a
> player is without having to check all the other players.
> Cheers,
> Ciarán
>

--
Willem Bogaerts

Application smith
Kratz B.V.
http://www.kratz.nl/

Good idea! Ha ha and I thought someone was gonng come back with some
crazy long SQL statement!
Cheers
Willem