Hey guys sorry to bother you, but I am a complete newbie at ASP and SQL, and I hope you guys could help me?

What I'm doing:

I have people and their scores in a table, what I would like to do is find the 10 closest scores in the table, does this make sense?
(SQL=...Wink

Any help? Big Smile

If it helps...
-table contains the colums: personID, person, pScore1 - pScore10, totalScore.

Thanks! I can answer any question you have to help you help me.



-mnuber