| Subject | Getting the 'closest' return |
|---|---|
| Author | dleec45 |
| Post date | 2004-06-09T03:43:54Z |
How do I write a query which will return the closest value in the
where statement. If I have a bunch of numbers in a table that has
values like 100, 200, 300, 400 and my where clause looks for 249 or
250, how do I return 200 or 200 and 300, whatever the case may be?
where statement. If I have a bunch of numbers in a table that has
values like 100, 200, 300, 400 and my where clause looks for 249 or
250, how do I return 200 or 200 and 300, whatever the case may be?