>Is there a command in SQL 7 that is comparable to go bottom? I looked at fetch, but couldn't seem to get it to give me what I wanted.
>
>TIA

If you just want the last record possibly returned by a SELECT statement, you could try
SELECT TOP 1 field1, field2 ;
  FROM table ;
  WHERE search_criteria = 1 ;
  ORDER BY field1 DESC