title: Month & Year filter in SQL Server
body: <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>