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