CASE in select statements

Posted in 1999

samir BADAOUI — Mon, 09 Aug 1999 09:55:10 PDT — source: Informix-list mailing list archive (1991-1998)

hi friends, my question is : since witch version can we used case in select statements (verion of ISQL ) (exemple of statement : select case when col1>0 then col1 end case when col2>0 then col2 end case when col3>0 then col3 end from ... where ... ) thanks ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

↪ replying to samir BADAOUI

Art S. Kagel — Mon, 09 Aug 1999 14:46:58 -0400 — source: Informix-list mailing list archive (1991-1998)

Version 7.30 and later. Art S. Kagel samir BADAOUI wrote: > > hi friends, > my question is : > since witch version can we used case in select statements (verion of ISQL ) > (exemple of statement : > select case when col1>0 then col1 end > case when col2>0 then col2 end > case when col3>0 then col3 end > from ... > where ... > ) > thanks > > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com