Oninit cdi / Archive
Talk to an expert →

Re: CASE in select statements

Posted in 1999

samir BADAOUI — — source: Informix-list mailing list archive (1991-1998)

Hi Kagel, you mean version 7.30 of online or isql product. thanks >From: "Art S. Kagel" <kagel@bloomberg.net> >Reply-To: kagel@bloomberg.net >To: informix-list@iiug.org >Subject: Re: CASE in select statements >Date: Mon, 09 Aug 1999 14:46:58 -0400 > >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 ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

Related threads