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