Data Conversion

Posted in 1996

"Stefan P. Romankiw" — 11 Sep 1996 14:23:11 -0400 — source: Informix-list mailing list archive (1991-1998)

We are running OnLine 7.12. I am looking for a way to convert a numeric to a character. The query would look something like this: Select string(123.456,2) from ratetbl; Where : 123.456 is the value to convert 2 is the scaling factor The result of this query would be '123.46'. Any thoughts? Thanks. Steve Romankiw Executive Risk Inc. SRomankiw@execrisk.com