Peter Brawley wrote:
> />Is there an efficient way to find the closest numerical value, across
> >three columns? I do not know if there is a way to find it across one. /
> Not sure about efficiency, but if the criterion number is @n, do you
> mean ...
> SELECT LEAST( ABS(MIN(@n-col1)),
> LEAST( ABS(MIN(@n-col2)),
> FROM ...
I think the formula is just right - very clever. But is it possible to
make sure that col1, col2 and col3 are all from the same record?
Thanks in anticipation