Re: Case insenstive searches

Posted in 1996

Rodrigo Prenafeta — 14 Nov 1996 18:18:38 GMT — source: Informix-list mailing list archive (1991-1998)

Roland Mueller (rolandm@scn.de) wrote: : Igor Shcherbakov wrote: : > : > In article <01bbcce4$422bd800$0ea490cc@rob.polygon.net>, rob@polygon.net : > says... : > # : > #What is the best way to accomplish case-insentive searches using : > #Informix SQL??? SELECT * FROM table WHERE field = '[Hh][Ee][Ll][Ll][Oo]' --****************************************************** * Rodrigo Prenafeta * e-mail: rprenafe@dcc.uchile.cl * * * rprenafe@marinetti.cl * ******************************************************