find position of row in set of rows

From: cate <>
Date: Thu, 28 Jan 2010 10:49:56 -0800 (PST)
Message-ID: <>

I have a table ordered by date. When I find a specific record in this set, I want to know what its position is in this ordered list.

I could get the date from the record found and count dates above or below, but is there a better way?

Thank you. Received on Thu Jan 28 2010 - 12:49:56 CST

Original text of this message