>How about:
>
>

>SELECT * FROM yourtable WHERE RecNo() = RecCount()
>

>
>>Is there a way to select the last record of a table with only a select statement?

It woudldn't work if last record is deleted. Try

SELECT MAX(RECNO()) AS MaxRN FROM prod ;
	INTO ARRAY aMaxRecno
SELECT * FROM prod ;
	WHERE RECNO() = aMaxRecno[1]