 <p>If you are trying to do the opposite, (provide a single value and find all the rows where the min and max age values bracket the provided value), then try</p> <pre><code>Select * From table Where @myValue Between min_age And max_age </code></pre>