Re: Finding nearest numeric value

>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