title: Extract year from datetime format
body: <p>I'm doing my final year project using asp.net as front end and SQL Server 2005 as back end</p>
  
  <p>My question is: I want extract only the year from datetime format. And use the year to filter data </p>