D
[quote user="boohiss"]Unless LIMIT is new to SQL Server 2005 or something else I'm unaware of, you can't use it on SQL Server. You *can* use "SELECT TOP 50" or "SELECT TOP 10%", which functions like LIMIT in many ways, but it's not the same.Unless, again like I said, it's new to SQL Server 2005, which would be great.[/quote] Well, there's always SET ROWCOUNT <whatever>, though I'm not sure that would be exactly the same.