plus or minus

A

asc4john

Is it possible to create a qurery that finds a value that is within a
certain tolerance.
i.e. SELECT * FROM tbl WHERE tbl.field is plus or minus 10 of "some
value";
 
J

John Spencer

One method

SELECT *
FROM Tbl
WHERE Abs(SomeField - SomeValue) < =10

Another
SELECT *
FROM Tbl
WHERE (SomeField - SomeValue) Between -10 and 10
 
Top