It is a real pain in the ... that every sql server uses it's own select top equivelent... Here follows a list of some of the ones I found: SQL Server : SELECT TOP 10 * FROM [TABLE] DB2 : SELECT * FROM [TABLE] FETCH FIRST 10 ROWS ONLY PostgreSQL : SELECT * FROM [TABLE] LIMIT 10 Oracle : SELECT * FROM [TABLE] WHERE ROWNUM <= 10 Sybase : SET ROWCOUNT 10 SELECT * FROM [TABLE] Firebird : SELECT FIRST 10 * FROM [TABLE] MySQL : SELECT * FROM [TABLE] LIMIT 10 I haven't tested all of these... I...