Re: Conversion fn?

Posted in 2000

Mark D. Stock — Wed, 23 Feb 2000 22:44:10 +0000 — source: Informix-list mailing list archive (1991-1998)

Usha M Rao wrote: > > Is there any character to numeric conversion function in Informix? As the Clown says, it's implicit, but what do you want to do? You can force the implicit conversion by adding a numeric value or zero to your char value. For example: SELECT my_char_value+0 FROM my_table : Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |What year 2000 bug? year 2000 bug? |/// / ////| | |year 2000 bug? year 2000 bug? year |// / /////| | |2000 bug? year 2000 bug? year 1900 |/ ////////| +----------------------+-----------------------------------+-----------+