>Doesn't SQL Server have a limit-type statement? Sybase doesn't but I'm >pretty sure MS added one....back, back, back into the recesses of my mind, >I think its like: >select top 100 * from table Absolutely correct.