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.