SQL Server tutorial 43: Using conversion functions.

[louisvankroen]

Hi! well, I understand, but I need know how show into tabla these data with those changes. I used the same steps. With the CAST or CONVERT, both i used for convert a field type FLOAT to INT, but I should insert or update the new field with the new data type in the table.

SELECT CodSigla, CONVERT (INT, CodSigla) as  IDSigla from Manejo

I need put into the table "Manejo" the new IDSigla field with all registers. Or maybe update CodSigla to INT, for when I use "SELECT * FROM Manejo" can show the change of  FLOAT to Integer in this table.