title: substring operation on blob text in informix
body: <p>How can I substring a text of BLOB datatype in informix? If the operation is possible only on text of char datatype, is it possible to convert from BLOB to char (like to_char in oracle)?</p>
  
  <p>Thanks in advance,</p>