>I am trying to change a Character Binary field in a table to a regular character field on the fly. Does anyone know how to do this? I don't see anything in alter or create table.
>
>Thanks

---

alter table mytable alter fieldname C(length)

will probably work