Quote:Create table abc (a varchar(100))
Insert into abc values ('20')
After that I altered the Column to int. After changing in table the value is 20 only.
Again altered the Column as char.note char only I put not like as char(10). In table the value is changed to *.how can I get the old value 20.please reply me ASAP.
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)