SQL - Informix - 将列的数据类型从numeric更改为character

I have a temp table that has numeric integer values in one column. I want to either replace the integer values with character values based on some criteria or I want to add another column of character type that automatically inserts values into itself based on some criteria.I have a temp table that has numeric integer va