need help to update a field into a new field but

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

need help to update a field into a new field but

Author

Topic

keesky
Starting Member

2 Posts

Posted - 2008-04-23 : 08:33:18

Hello everyone...

I am using SQL Server Enterprise Manger Version 8.0, and I need to update the values of Field one into a new Field of a different type. Here is my example, say I have a table called tblResults with field name "resultOne" and I want to update the values of "resultOne" into a new Field called "resultTwo", but resultOne is of type "nvarchar" and resultTwo needs to be of type "int". I need to run an update query that copies all the values of resultOne into resultTwo? Is there any way I can make the string values to be copied into the int values.

All the values in resultOne have numbers but the type is "nvarchar"?

Hence resultOne has values like 12.09, -100.98, 2827.98 and all of them are numbers, so there must be some way to copy it into resultTwo that is of type "int", I cannot manually do it because i have 35,000 records.

Could someone guide me in the right direction.

Thanks,

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-04-23 : 08:38:11

try using CAST function

UPDATE Table
SET resultTwo=CAST(resultOne as int)