Hi Ed, May you could join the table to itself, using a join criteria of index and position :
SELECT * FROM ROWS AS R1 LEFT JOIN ROWS AS R1 ON (R1.index=R2.index AND R2.X<=Right) LEFT JOIN ROWS AS R3 ON (R1.index=R3.index AND R3.X>=Left) LEFT JOIN etc etc... Does that help? Arnaud -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]