Re: Upper case function in index?

>I assume some of you must experience the same situation. I need building >an index upon people's name. I would like sort them in the order of >either upper case or lower while name field allows mix-cased. I can not >find a way in Informix to do it so I have to add a column of >single-cased name for sorting purpose only. It is kind of waste, isn't >it? Can any of you out here shed a light on the issue? You can use stored procedures to achieve this. See the examples of SPL at the International Informix Users Group (IIUG) web site at http://www.iiug.org/software/software_index.html#ISQL . In a few weeks you'll be able to use native SQL to accomplish this with the Informix Dynamic Server version 7.3. Note that this is a Frequently Asked Question, and you could have also found the answer on the Informix FAQ, also maintained through the good graces of the IIUG. ___________________________________________________________ Clem Akins (aka clem@informix.com) Informix Software, Inc (Standard disclaimers apply) International Technical Support Last seen: Sitting on Highway 101, Menlo Park, California