Thank you for your brilliant answers everybody ! > in mysql, philippe, you restrict the number of rows returned using the > LIMIT keyword > > SELECT id > FROM table > WHERE ref < [thisone.ref] > ORDER BY ref DESC > LIMIT 1 > > > good one, josh > > > rudy