alias and select filter from sql

Posted in 2008

vchu via DBMonster.com — Tue, 25 Mar 2008 15:15:41 GMT — source: Usenet: comp.databases.informix

sorry i am a new babie in INFORMIX sql can i ask you guys help me to convert this? select MyLocationStatus as If([state= "V", "valid", If([state= "I", "Invalid",If([state not in ("V","I", ""NULL"))) from location; result rows should show "VALID", "INVALID" or "NULL" select Round(([act_arrival_dt]-(DateValue([appt_nlt_date])+TimeValue( [appt_nlt_time])))*24*60) AS VarianceInMins from appointment; Thanks Vc -- Message posted via http://www.dbmonster.com

↪ replying to vchu via DBMonster.com

Superboer — Tue, 25 Mar 2008 08:45:47 -0700 (PDT) — source: Usenet: comp.databases.informix

SELECT nvl(MyLocationStatus,"NULL") WHEN 'I' THEN 'INVALID' WHEN 'V' THEN 'VALID' WHEN 'NULL' THEN 'NULL' ELSE 'UNKOWN' END FROM location > select Round(([act_arrival_dt]-(DateValue([appt_nlt_date])+TimeValue( > [appt_nlt_time])))*24*60) AS VarianceInMins from appointment; hmmm dono whar the above all means, however this can be done in an spl. Superboer. way fast=http://www.clipjes.nl/clip/nederlands/n/normaal_- _oerend_hard.html