TSQL Including fiscal year in select statement based on the date
<p>I need to include the fiscal year in my select statement based on today's date e.g for 12/30/2016 2016-2017. The fiscal year starts as of July 1. As of July 1,2017 it should calculate 2017-2018. How can I accomplish that?</p>

<pre><code>ClaimNo
20161030
20161124
20160815
20170115
20180101

SELECT * 
FROM TABLE
WHERE ClaimNo LIKE '2016%' OR ClaimNo LIKE '2017%';
</code></pre>