OK.... i can't seem to get this to work... im doing an insert on a table and i want to move a VARCHAR into a INT. I'm trying to CAST it, but its not working... any ideas?
INSERT INTO tbl
CAST(NAME AS INT),
The receiving table is set up to receive as an int..
Any help is appreciated
Hi Dieter -
I just cant figure out how to successfully cast a VARCHAR(5) into a INT field through a select.