Oracle: DECODE function <==> Informix: ???? function

Posted in 2000

alkandery75 — Tue, 09 May 2000 05:29:19 -0700 — source: Informix-list mailing list archive (1991-1998)

I would like to ask about is there any function in informix equivalent to the DECODE function of oracle. very urgent thanks alkandery75 alkandery75@hotmail.com * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!

↪ replying to alkandery75

Rudy Fernandes — Tue, 09 May 2000 09:16:08 -0400 — source: Informix-list mailing list archive (1991-1998)

alkandery75 wrote: > I would like to ask about is there any function in informix equivalent > to the DECODE function of oracle. > very urgent > thanks > alkandery75 > alkandery75@hotmail.com > > * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * > The fastest and easiest way to search and participate in Usenet - Free! There is a DECODE function available in Informix v7.3 onwards (at least!). One can't be sure that it has the same functionality of the Oracle-DECODE, though. If you could explain how you want to use DECODE, there's bound to be some way to do the same in Informix (any version) Rudy