Just like "Set Near On" command in Foxpro.

Best Regards,

Luqman

In reality, you could easily do this with a sql statement, though not with
seek:
Basically you are looking for the smallest difference between your field and
your required value

SELECT TOP 1 Field1, ABS(Field1-12) FROM TABLE ORDER BY Field1-12

To return the record that has that value:

SELECT * FROM TABLE A WHERE EXISTS(SELECT TOP 1 Field1, ABS(Field1-12) FROM
TABLE B ORDER BY Field1-12 WHERE A.PrimeKey= B.PrimeKey )

As the "Set Near On" is implemented by the specific engine in Foxpro, there
is no such corresponding function in ADO. You have to write code to
implement this function manually.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copy Right, 2001 Microsoft Corporation. All rights reserved.

Regards,
Kally Wang
Microsoft Support Engineer

==Original Message==

Subject: Seek Nearest Match if exact match not found ?
Date: Fri, 5 Oct 2001 13:15:54 +0500
Newsgroups: microsoft.public.vb.database.ado

Using Seek of ADO, If I search for 12 and it is not found, the match should
return nearest to the match say, 11 or 14. Is it possible ?

Just like "Set Near On" command in Foxpro.

Best Regards,

Luqman