Was just wondering if anyone knew how to execute a pervasive statement with a syntax similar to a mysql query of

SELECT * FROM table LIMIT x,y

i want to query starting from row x with a limit of y results. I looked into TOP but it seems it will only limit the number of results and not the starting row.

There is no LIMIT syntax in Pervasive.SQL. You can, if you're using V8, us the TOP statement and a WHERE clause to set the start row. Something similar to:
SELECT top X FROM table WHERE field=Y
Also, if you really need this syntax contact Pervasive to tell them you need it.
Hope this helps.

ok no worries. thanks for that.