Re: Case insensitive search

Posted in 1997

Glenn Travis — Mon, 28 Jul 1997 10:30:25 -0400 — source: Informix-list mailing list archive (1991-1998)

Jay D. Sullivan wrote: > Hi. > > We have Informix OWS 7.22 for NT and I'm wondering if there is a way > to do > case-insensitive searches. > > It looks like Informix does not have a native UPPER() function. Last > year > tech support sent me an UPPER stored procedure which basically parses > a > string and changes 'a' to 'A', 'b' to 'B' and so on. With this > procedure, > I can run a query like "select custname from customer where > upper(custname) > like 'CON%'". The problem with this method is that Informix > won't/can't > use the index on the custname field. So, the query can be *really* > slow if > the table is large. > > Is there another method which I'm overlooking? Can OWS or ODS be > configured to be case-insensitive? > > Thanks. > Jay D. Sullivan > Economic Analysis Group, Ltd. 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...