To find the nearest value in number_column to some CONSTANT (where you replace constant with a number), try:select *,(number_column - CONSTANT)^2 as d from tablename order by d limit 1; Does that do it for you? Sean
It does ideed, not that I understood how, but I will find out. Thank you very much. Poul ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
