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.
>
>>
>>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 >