 <p>This should work.</p> <pre><code>SELECT * FROM player WHERE height &gt; CASE WHEN @set = 'tall' THEN 180 WHEN @set = 'average' THEN 154 WHEN @set = 'low' THEN 0 END </code></pre> <p>I'll leave the &lt; case for your enjoyment.</p>