How to convert Integer to ASCII

I was incorrect on identifying which field was receiving the error. It turned out to be another field that was set to integer yet receiving character data. I would still like to know if there is a function to convert integer to ASCII. Thanks.

mark.baumgartner@cardhealth.com wrote: > > I was incorrect on identifying which field was receiving the error. It turned > out to be another field that was set to integer yet receiving character data. > > I would still like to know if there is a function to convert integer to ASCII. > > Thanks. Informix will auto-convert for you whenever it can. If necessary, say when you want to do something a little bit complicated, you can create a temp table with CHAR data fields, and then SELECT your integer data and INSERT it into the temp table. You can then play with it as ascii text. -- Usenet, a global collection of flaming opinions and senseless babble, was designed as a way to eat up precious spool space on a system's hard drive. It also is a way for people to distribute pornography. (By Robert A. Hayden <www.geekcode.com>)