Re: Upper case function in index?

Yes, it is a waste. Supposedly, in 7.3 there is supposed to be an upper function to allow this (although not sure if you'll be able to index based on it - I suspect not). This has been a long standing gripe, but should be fixed soon ! Vic Xin Zhou wrote: > Hi, there, > > 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? > > Thank you in advance. > > Sims > xhsims@erols.com -- Vic Goldberg Manager, DBA Team, Cornell University (607) 254-7441 (Voice) (607) 255-6982 (Fax)