No prob. Enjoy.
Bill
>That did it. Thanks!
>
>Jerry
>
>
>>One way is you can use the TOP N clause and order the results so the last 100 rows will be at the top:
>>
SELECT TOP 100 * FROM MyTable ORDER BY MyAlphaField DESC
>>
>>Bill
>>
>>>Is there a way to query the last 100 records in a SQL Server table?
>>>
>>>Thanks,
>>>
>>>Jerry
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.