Re: Case sensitivity & Informix SE

Posted in 1996

Dirk Schmidtpott — Mon, 15 Jul 1996 10:29:42 +0200 — source: Informix-list mailing list archive (1991-1998)

garry wrote: > > Hi, > > Is there a way to make "like" or "matches" comparisons case > insensitive. Sybase has functions called "lower" & "upper" to change > the case of a string, the contents of a variable or the contents of a > column. Oracle also has similar functions, but I don't remember their > names. > > TIA, > > -garry > > ---------------------------------------------------------------------- > Garry Saperstein > > Bitsource, Inc. voice: 415.919.0651 > 888 Villa Street fax: 415.919.0655 > Suite 420 email: garry@bitosurce.com > Mountain View, CA 94086 http://www.bitsource.com > ---------------------------------------------------------------------- Hi Garry, the functions in Oracle are called "lower" and "upper", too. And I also did not find any hint in the manuals to a function in Informix, that does the same. Is it possible, that they don't have an equivalent ? I can't believe it ! Cheers, Dirk --------------------------------------------------- Dirk Schmidtpott S I E M E N S EMail: schmd@dbm212.pdb.sni.de ============= Phone: 0049-5251-8-14922 N I X D O R F Fax : 0049-5251-8-17905 The above statements and opinions are my own and do not necessarily represent those of my employer. ---------------------------------------------------