<h1 id="cleaner-code-in-the-where-clause"><a aria-hidden="true" class="anchor-heading icon-link" href="#cleaner-code-in-the-where-clause"></a>Cleaner Code in the Where Clause</h1>
In your code start your WHERE clause with a <code>WHERE TRUE</code> so that all logical statements are in <code>AND</code> statement on subsequent lines and therefore more easily commented out.
<pre class="language-sql"><code class="language-sql">SELECT *
FROM dbo.my_table
WHERE TRUE
AND person_id > 5
AND age BETWEEN 18 AND 65
AND first_name LIKE '%Paul%'
</code></pre>

Cleaner Code in the Where Clause


The hyperfixated rabbit hole diving knowledge base that is my brain looking at technology.
