pain_killer , the point about NOT using the Year() function is that it will make better use of any index.
Sorry, my english is very poor, and sometimes I don't understand what is the point of the problem, so please be patient to me
. In this case I had compare IO, TIME statistics and execution plans. YEAR() function and explicit date comparing in this case looks identical. So the question is: why use YEAR() function? I think that this looks clearer to me, and it uses only one parameter (2006 in this example).