Month & Year filter in SQL Server
<p>I have a SQL Server table with following columns:</p>

<p><a href="https://i.stack.imgur.com/FZSTZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FZSTZ.png" alt="SQL Table"></a></p>

<p>Now, I have to write query which will return me the records where "Month > May" and "F Year > 2016".</p>

<p>I am providing both "Month" (May) &amp; "F Year" (2016) from my application. There are multiple records with the same Month &amp; F Year column values.</p>

<p>I tried with Date part, Cast etc. but not getting required result.</p>