plus or minus

[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";

 

[John Spencer]

One method

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

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