At 08:33 PM 11/02/2008, you wrote:

>Just a short question.
>
>Firebird can do this:
>
>SELECT FIRST 250 ProductNumber, StockCount from DWIStock
>
>In MS SQL the same is
>
>SELECT TOP 250 ProductNumber, StockCount from DWIStock
>
>
>Which is standard SQL ?
>Firebird or MS SQL ?

Neither.

The ROWS syntax implemented in Fb 2 is standard, e.g.
SELECT ...
[ORDER BY <expr_list>]
ROWS <expr1> [TO <expr2>]

./heLen