Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif
SELECT * FROM TableName WHERE Year( DateColumn) = SearchValueForYear
SELECT CONVERT(VARCHAR(26), GETDATE(), 23)
SAMIR Sr. Software Engineer
IT KNOWLEDGE IS APPLIED KNOWLEDGE So Just Do It
SELECT * FROM TableName WHERE Year(DateColumn) = 2013
Login to post response