That actually seems to work but with one minor flaw. With my test data

id time name

1 01:15 Bob

2 01:28...

That's more like it That sounds like it will work, the only thing I'm concerned about is performance because we could be talking...

Thanks for the reply don but I don't see how that is any different than ordering by a normal date column? How would I be able to determine the rank...

Well, it's going to be a ranking table for lap times for a computer game. People should be able to submit their times and they will show up in a...

Thanks, that was useful. However, I think I haven't explained my problem properley

I need to be able to select inidividual records from the...

Thanks for all the excellent replies. In the end I had the most success with Jeff's approach.

Thanks again!

Thanks for that Steve.

Unfortunately my SELECT prodcedure is much more complicated than the one illustrated. The reason I'm doing this is that I don't want to have to maintain...