Anand

> SELECT TOP n * FROM <table> as used in MS Access/SQL Server...
>
> While searching for this on the VB Forums, I also found another
> way of doing
> it in Oracle, using the Row_Num, but both these approaches have
> failed in
> Firebird.

You can use Select First n * from ......
Or Select First n Skip m * from ......

Florian