[coolminded]

hi,
can i change the datatype of any field from numeric to varchar, or any other type..
i have a field 'id' which is numeric type,
but now i have to change it to varchar(20),
is it possible to do.
thanx in advance.

[rski]

Try this

Expand|Select|Wrap|Line Numbers

1. alter table q alter column i type varchar(20);
2.  

it works if there are no numbers in i column which has more than 20 digits.