Posted by Ian B on 10/20/05 03:11

Not quite what you asked for but

select num, abs(num - $reqd ) as srt from t1 order by srt limit 11

will give you your record plus the nearest 10 records to it

Just a thought.

Ian

[Back to original message]