Re: Problem with char to numeric

Posted in 2000

Mark D. Stock — Thu, 07 Sep 2000 20:42:51 +0100 — source: Informix-list mailing list archive (1991-1998)

Jos' Manuel Coca wrote: > > Sorry for my english... > I have a table in another database with a char field, i need to create a > view that return a numeric field that represent the char field of the table. > The char field contents always numbers. What can I do to query the table > with the char and obtain a numeric??? Try: SELECT my_char+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 +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+