Re: Case Sensitivity

Posted in 1998

Clem Akins — Fri, 14 Aug 1998 08:41:13 -0700 — source: Informix-list mailing list archive (1991-1998)

See the 7.3 version of IDS, which provides a case-insensitive search via the UPPER, LOWER, and INITCAP functions. You can find more info from TFM, available from the top level of the Informix web site at http://www.informix.com . At 10:57 AM 13-08-98 -0500, Kevin Calcagno wrote: >Can anyone tell me how to overcome case-sensitivity when doing a select >query such as: > >SELECT * FROM docs >WHERE subject like '%data%';> >... without having multiple OR... clauses with every combination of >capital and non-capital letters? > >Thanks in advance, >Kevin Calcagno _____________________________________________________________ Clem Akins (aka clem@informix.com) Menlo Park x5937 Customer Course Development Informix Software, Inc Last seen: Riding the waves of a 5.3 California earthquake!