title: Converting a String to HEX in SQL
body: <p>I'm looking for a way to transform a genuine string into it's hexadecimal value in SQL. I'm looking something that is Informix-friendly but I would obviously prefer something database-neutral </p>
  
  <p>Here is the select I am using now:</p>
  
  <pre><code>SELECT SomeStringColumn from SomeTable
  </code></pre>
  
  <p>Here is the select I would like to use: 
      SELECT hex( SomeStringColumn ) from SomeTable</p>
  
  <p>Unfortunately nothing is that simple... Informix gives me that message: 
  <em>Character to numeric conversion error</em></p>
  
  <p>Any idea?</p>