Re: Characteristic functions with Informix?

This should be easy to solve in version 7.3 with the inline case statement and possibly with decode as well. You find documentation for this at http://www.informix.com/answers in the SQL syntax manual. In earlier versions I have no better idea than a special stored procedure for each function which probably wouldn't help you much. On Wed, 22 Apr 1998 16:19:27 -0700, Joe Weinstein <joe@weblogic.com> wrote: >Hi folks. I would like to write some SQL for Informix, using >characteristic functions. Has anyone had any luck in this area? >For those who don't know what characteristic functions are, you >can still help me: Is there any in-line functionality in Informix >SQL similar to the C code ((n > 0) 'true':'false')? > >eg: >select > 'Column one is ' > || ((col1 > col2) 'bigger' : 'smaller') > || ' than column two' from myIntTable; > >yielding > >'Column one is bigger than column two' >'Column one is smaller than column two' >... etc > >Thanks! > >-- > >Joseph Weinstein Staff Engineer http://www.weblogic.com >WebLogic, Inc. 415-659-2621 joe@weblogic.com >See our newsgroups: http://www.weblogic.com/services/newsgroups.html Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)