Re: Case insenstive searches
Rodrigo Prenafeta wrote:
>
> 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]'
Of course you mean:
SELECT * FROM table WHERE field MATCHES '[Hh][Ee][Ll][Ll][Oo]'
Cheers,
--
Mark.
+-------------------------------------------------------------------------+
|Mark D. Stock - The West Solutions Group http://www.west.co.za |
| The Informix FAQ is at http://www.iiug.org |
|mailto:marks@west.co.za +------------------------------------------------+
|Tel: +27 11 803 2151 |If it doesn't work... force it! |
|Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! |
|Cell: +27 83 250 2325 |Well, that's how I code anyway! |
+------------------------+------------------------------------------------+