Hi,

I use sql server 2003 data base. I want to change one of the field in a table from int to varchar without losing any data. Is it possible? If so, please let me know how to do it.

Thanks in advance.

GG

create a new column of varchar and update it with exisitng column
UPDATE myTable
SET NewvarcharCol = CONVERT(varchar(20),intcolumn)

Check your data and drop the original column..

why are you converting your column data type..?

there is no SQL Server 2003.. (SQL server 2000 only)