title: SQL - Informix - Changing the datatype of a column from numeric to character
body: <p>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.</p>
  
  <p>If x &lt;= 1, change to "SP" or make new column and store "SP" in that row<br>
  If x > 1, change to "FA" or make new column and store "FA" in that row<br><br>Also, alter commands are not allowed on temp tables in my version of Informix.</p>