SELECT * FROM ; >> ( select TOP 50 * FROM MYTABLE ; >> WHERE (&cFilter.) and MY_PK < nPk ; >> order by PK ; >> ) dt1 ; >>UNION ALL ; >>SELECT * FROM ; >> (select TOP 50 * FROM MYTABLE ; >> WHERE (&cFilter.) and MY_PK > nPk ; >> order by PK DESC ; >> ) dt2 >>>