CREATE CURSOR MyTable (PK_MyTable I, MyTableDesc C (50), ts T)
INSERT INTO MyTable VALUES (1, "Oldest record", DATETIME())
WAIT WINDOW TIMEOUT 1
INSERT INTO MyTable VALUES (2, "Second oldest record", DATETIME())
WAIT WINDOW TIMEOUT 1
INSERT INTO MyTable VALUES (3, "Newest record", DATETIME())

SELECT MyTable.* FROM MyTable WHERE MyTable.ts IN (SELECT MIN (MyTable.ts) FROM MyTable)

HTH

>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?