HEX Conversion for CHAR data

Is there a way to convert CHAR data to HEX data in Informix 7.30? I realize that there is HEX conversion function for integer, but I would like to convert CHAR data to HEX. Thanks, Tod

On Thu, 2 Dec 1999 15:50:16 -0800, "Tod Johnson" <tod_johnson2@hp.com> wrote: >Is there a way to convert CHAR data to HEX data in Informix 7.30? I realize >that there is HEX conversion function for integer, but I would like to >convert CHAR data to HEX. > If the value in the CHAR field represents an integer value you can select it's content in a temp table where you defined the corresponding column integer. HTH Reinhard