🚀 go-pugleaf

Hi Red,

you can use the following :

select fld_1-2.99999999,fld_2 from table1 where fld_1-2.99999999 > 0
order by 1

select fld_1-2.99999999,fld_2 from table1 where fld_1-2.99999999 < 0
order by 1 DESC

In the first row of seach select you find the value with the minimum 
deviation, in the first one the minimum positive deviation and in the second 
one the minium negative deviation.

Hope that helps

Mike

"Red" <nospam_kandw321@icrossroads.com> schrieb im Newsbeitrag 
news:428a630b.73020187@newsgroups.borland.com...
On Tue, 17 May 2005 23:23:52 +0200, Aage Johansen
<aagjohan@offline.no> wrote:

>b.p.i.general and b.p.i.sql (and others) are open, IB/6 is OnTopic
>(AFAIU), and with healthy traffic.

Thanks.  I've added them to my "subscribed" list.

>As for your question, could you give some examples of what you want.
>


In the database there are 6 records as follows

fld_1,    fld_2

2.33468761, 8
2.87764586, 3
3.00177652, 5
3.20464536, 9
3.29676754, 2

Value to lookup in fld_1:  2.99999999

Nearest single record would be: 3.00177652, 5

I would grab the five, and continue with my next task...

I hope this illustrates my problem.

Thanks for your help.