Re: Case insensitive search

Glenn Travis wrote: > ODS 7.3 (ship Q1 '98) will have this plus LOWER, plus Enterprise > Command Center (for unix), plus a WHOLE lot more... Ask your Informix > rep for more info... Ah yes, finally after all these years of asking for it! Somehow, I'm sure there's a "however" coming up... Here it is: However, I suspect we will still not be able to index against UPPER(name), because the key value in the row would not match the key value in the index entry. This means that a case insensitive search would still be as slow as [I've heard] the Oracle case-insensitive search is. Still, it would be no worse than Oracle in this matter. (Some selling point! ;-) And the capability would finally be there. So let's give it .. well, 2 cheers! (way to go. yay.) If I recall correctly, the ability to index on a function of a column [like UPPER() or LOWER()] exists only in XPS (maybe in Universal Server as well?) Corrections anyone? -- -- Jake (In pursuit of undomesticated aquatic avians) +----------------------------------------------------------+ |Aside from that, how did you enjoy the play, Mrs. Lincoln?| +----------------------------------------------------------+