title: How to select rows if the date between is in current month
body: <p>I have a table that has two fields <code>FromDate</code>, and <code>ToDate</code>, and lots of data in it.
  What I want is to get the rows If current month is midst of these fromdate and todate.</p>
  
  <p>Eg: 
  (1) <code>FromDate = 20/Dec/2013 &amp; ToDate = 15/Feb/2014</code>, so it should appear if <code>Current Month (Jan 2014)</code> is selected. </p>
  
  <p>(2) If <code>FromDate = 05/Jan/2014 &amp; ToDate = 10/Jan/2014</code>, this also should appear if current month is selected.</p>
  
  <p>Can anybody give me a query that returns a result like this?</p>
  
  <p>Edit: I want to check for a month, Not a Date. Eg: To get all rows for Jan 2014 If the date between fromdate and todate lies  in.</p>