See DATEPART() function in BOL.

>You're right
>
>Somehow, that’s the reason I started this thread, I’m struggling with how to include functions like “year()” into a SQL statement for SQL server.
>
>Not knowing how to retrieve the year out of the date I went into the null columns etc.
>
>I’ll get rid of the Year column as soon as I find a way to retrieve the year as a single column.
>
>Regards
>
>
>Oscar Corte
>
>
>>I'm not sure that's good idea to have separate field for year because you cam always get it from date field.
>>