Re: CASE WHEN construct in informix??

Alexandros Labrinidis wrote: > > Hello all. > > 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 > Yes, it does, in version 7.30. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 --- If all else fails, read the instructions and the release notes. Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/ ---