I have a table where I want to move data that is in a INT column to an Alphanumeric column in the same table. I tried doing an insert into that column with this command below but it didn't work out as I expected and that might be because of the different formats.
SET <column from copy>=<column to copy>
WHERE <column from copy> IS NOT NULL
There are 5773 rows in this table so I can't do them one by one. I think I need to use a CAST statement but don't know how iterate between each record.