title: SQL Server: birthday Leap year
body: <p>I am trying to retrieve a data based on:</p>
  
  <p>Sql query to display list of employees  whose name start with letter  ‘f’ and year of birth should be leap year.</p>
  
  <p>tried uisng function, if only for the leap year: ( help from one of my peer)</p>
  
  <pre><code>CREATE FUNCTION leapyear (@year INT)  
  RETURNS INT  
  AS  
  BEGIN  
  RETURN(IIF(DATEPART(dd,(EOMONTH(CONCAT(@year,'0201')))) = 29,1,0))
  END
  </code></pre>
  
  <p>But when we need name along with year then what to do.</p>
  
  <p>More over besides using function is there any simple way to do it( Involving less code)</p>