Jeff Moden (2/2/2009)
The real answer to this question should have been "Since data is not guaranteed to be in any order in a table or query result, and ORDER BY would be necessary to determine what row # 6 would be... How do you want it sorted? Also, the order of columns in a database table should never be important because the order may change. What is the name of column #2?" 😉THAT would be the answer I'd be looking for to separate the Men from the Boys...
Very true in all respects. I appreciate that it's not necessarily the answer that helps the most in these threads but the analysis and the way you get there, a lesson well learnt. 🙂