Sergey

This is a good place for resources on SQL Server. I'll be cheking it immediately.

However, let me take advantage of your precense at the UT right now.

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.

Any hints are welcome

Oscar Corte


>>Hi Sergey
>>
>>Thanks a lot one more time.
>>
>>I bet you are one of the top message posters.
>>
>>BTW, where could I find what clauses and functions can be used as part of a SQL statement for SQL-server?
>>
>>Any reference to online information on MSDN, KB, Wwhite papers?, etc?
>>
>
>You should have SQL Server Books Online (BOL) installed on your PC with SQL clients tools. The latest SQL Server 2000 Books Online can be downloaded from http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp. I cannot imagine working with SQL Server w/o it.