Preserve data while changing column data type

[pullingteeth]

I have a univarchar column which cannot be indexed due to the length of the field. On my dev database, I can apply the index if I change the column to be a varchar.

Does anybody know if it is possible to convert a univarchar field to a varchar one on a production database without losing the data (assuming none of the data is unicode) ?

Thanks!