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

Yeah, Larry Miller just made that recommendation. I'll give that a try. Thanks for the assistance.