Re: Is this really NOT a feature of Informix????

In article <2qckdu$pel@news1.svc.portal.com>, Kellner Systems <pkellner@shell.portal.com> wrote: >Informix support told me the same thing. After lots of followup I have >decided that they really don't understand the need for this feature. >I posted a similar note and the best suggestion I got was to create >another column with the indentical data, but upshifted. Pretty bad in >my opinion. I vote for the wheels on the car!!! Don't let Informix tell you that this is not an important feature. As the recent discussion of a program for capitalization of names may have illustrated, this problem comes up again and again. Let's say I want my users to be able to search on a field that contains people's names. I can't count on them getting the capitalization exactly right , so I either have to keep two name fields, one with names upshifted for searching purposes, and one with varying caps. for display purposes (thereby wasting disk space and access time) , or make users access the data through a 4gl program that upshifts their search criterion and/or the data. This means my users can't use ace, perform, etc. I think this is a serious problem.