Characteristic functions with Informix?

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