title: SQL IF/CONDITIONAL Querty
body: <p>Is it possible to structure a query that will display a static value for a row based on a column? </p>
  
  <p>EG. </p>
  
  <p>In INFORMIX, the syscolumns type is returned as an integer. I would like to have it print out the table type as a string rather than an integer.</p>
  
  <p>For example, when I run a simple query to get the system tables </p>
  
  <pre><code>SELECT * FROM SYSCOLUMNS WHERE TABID &lt; 100
  </code></pre>
  
  <p>I get</p>
  
  <pre><code>    colname   tabid  colno  coltype collength
  ------------------------------------------------
      tabname     1      1      13       128
  </code></pre>
  
  <p>WHERE coltype = 13 corresponds to VARCHAR</p>
  
  <p>So my original query would give me</p>
  
  <pre><code>COLNAME    COLTYPE
  col1       0
  col2       1
  ...
  </code></pre>
  
  <p>But I want it to be returned as</p>
  
  <pre><code>COLNAME     COLTYPE
  col1       CHAR
  col2       SMALLINT
  ... 
  </code></pre>
  
  <p>Is such a thing possible to do in a single query?</p>