Thomas, > I usually solve this kind of problem with recusive CTEs providing a counter > for > the records returned, thus a "simple" select statement can nicely filter on > this kind of property without row numbers functionality.
Can you provide an example, please. I, for one, can't imagine how a CTE could be used for such a purpose. Sean