Re: Case Sensitivity

Posted in 1998

Oleg Milenkiy — Thu, 20 Aug 1998 16:25:52 -0500 — source: Informix-list mailing list archive (1991-1998)

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? > SELECT * FROM docs WHERE subject matches "*[Da][Aa][Ta][Aa]*"