Andrew2006 wrote:
> Hello,
>
> The SKIP command doesn't appear to be part of Informix 9.4 but is
> there an equivalent?
>
> I want to do a query like:
>
> SELECT SKIP 50 FIRST 10 * FROM <tablename>
>
>
> In mysql this would be done as:
>
> SELECT * FROM <tablename> LIMIT 50,10
>
> Thanks
>
> Andrew
>

Upgrade to IDS version 10. It has SKIP, FIRST, MIDDLE, LIMIT