Hi,

I need to select a range of ten rows around a specific row such that the
specific row floats to the beginning or end of the set as the set
approaches the beginning or end of the (ordered) table.

So, for example, if I had a hundred rows with the values 1-100 in them,
in no particular order, and the specific row was 2, I would need the set
1 2 3 4 5 6 7 8 9 10. If the specific row was 20, I would need
something more like 17 18 19 20 21 22 23 24 25 26, and if the row was
100, I would need 91 92 93 94 95 96 97 98 99 100.

Make sense? Anyone have a suggestion as to how I would go about this?

Thanks,
wbh