Do you replace lnNumberToExtract with a real number, like 10 or 20?

>hi,
>
>i get error message(SQL: Invalid TOP specification ),
>

> SELECT TOP lnNumberToExtract *, RECNO() AS rn,  ;
>

>
>i change the (newtable fields) to numeric,but still a messgae.
>
>any help.
>thanks.
>m.qasem