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