If construct

Ato · #1 (**permalink**) 07-03-09, 11:37

Hi, in the following mysql select statement i use an if construct to get a sign changed in the recordset.

SELECT a.fieldone, a.fieldtwo, if(a.fieldone="x",a.fieldthree,-a.fieldthree) as myfield FROM mytable a

I would like to have the same result on an informix db. Is it possible? If so, what is the If syntax?

Many thanks in advance.

//andrea

bigcalm · #2 (**permalink**) 07-03-09, 13:58

decode() is functionally similar.

Manual and examples here - IBM Informix Dynamic Server v10 Information Center

SELECT a.fieldone, a.fieldtwo, decode(a.fieldone,"x",a.fieldthree,-a.fieldthree) as myfield
FROM mytable a

Ato · #3 (**permalink**) 07-05-09, 05:02

thanks a lot, bigcalm

Tyveleyn · #4 (**permalink**) 07-06-09, 18:33

Or CASE. Is more useful then decode() when an unknown kind of different cases have to be covered by ELSE.

Code:

SELECT  CASE fieldone
	WHEN 'x' THEN fieldthree
	WHEN 'y' THEN ...
	ELSE -fieldthree
	END myfield
FROM mytable;

Regards,
Hans

sunbo · #5 (**permalink**) 07-27-09, 03:25

Dear players, do you need Gold for WOW? We provide you withWOW Gold, cheap WOW Gold, including
World of Warcraft EU Gold aWorld of Warcraft US Gold . Also we supply Metin2 Yang and Metin2 Gold to Metin2 players. Besides we also offer WOW Level Power Leveling.

Internet Services

Web Development

Digital Marketing

Consumer Tech