>does SELECT support a parameter that would allow the selection of the single oldest record in the table? Something like
>
>select min(datetimefield) from mytable
>
>but retrieving all the fields?
>
>Thanks
SELECT TOP 1 * FROM mytable ORDER BY datetimefield
You can ORDER BY datetimefield DESC to get the latest record.