Michael,

M> Firebird can do this:

M> SELECT FIRST 250 ProductNumber, StockCount from DWIStock

M> In MS SQL the same is

M> SELECT TOP 250 ProductNumber, StockCount from DWIStock

M> Which is standard SQL ?
M> Firebird or MS SQL ?

None of them I believe. The SQL sandard prescribes the ROWS clause:

SELECT ProductNumber, StockCount from DWIStock
ORDER BY ProductNumber ROWS 250

BTW, Firebird supports it (although not in full).

Ciao
--
Nando Dessena
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================