Re: CASE WHEN construct in informix??

>Does anybody know if Informix supports the CASE WHEN construct? > >I think it goes like: > CASE WHEN condition THEN value ELSE other_value END >and it should be in the SQL 92 standard. > >I've currently implemented this through a SQL user defined function, >(I tried to use CASE but didn't work, nor is there any mention of it >in the manuals). However, if it is supported, it would probably be >faster than my function, so I'd like to take advantage of it. > >thanks a lot, >alex > >-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > Alexandros Labrinidis, Grad. student in Computer Science @ Univ of MD > email: labrinid@cs.umd.edu web page: http://www.cs.umd.edu/~labrinid > > > > I think this is part of 7.30 Madison Pruet