I'm not sure that's good idea to have separate field for year because you cam always get it from date field.

>
>I have a date field and an integer field into an SQL table.
>
>I need to replace the integer field with the year from the date field. My problem right now is how to build the Update statement in order to accomplish that.
>
>So far:
>
> “update prueba set table1.year = year(table1.Date) where year is null”
>
>does not seem to work. Probably the Update statement is not well constructed, also I ve no idea of how to include functions into SQL statement like the one above.
>
< snip >