Is there a DECODE function?

Posted in 1997

Avi Abrami — Wed, 01 Oct 1997 03:34:13 -0600 — source: Informix-list mailing list archive (1991-1998)

Greetings All! As someone with an ORACLE background, and now working with INFORMIX, I wanted to ask if there is an INFORMIX equivalent for ORACLE's DECODE function. e.g. SELECT DECODE(col1,'X',0,'Y',1,2) FROM tbl1 i.e. select column "col1" from database table "tbl1". If the value of the column is the letter "X", return zero (0), if the value is "Y", return 1, otherwise return 2. All assistance will be greatly appreciated. Thanks (in advance), Avi. -------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to Usenet