Re: case insensitive matching

My thanks to Takeshi Hojo (take-h@ascii.co.jp) for the following information: ->Japanese version 4.X and ALS version 5.X have GRANT GROUP and ->REVOKE GROUP. It also have EMATCHES (case and code ignored matches) ->operator. Although this was part of a thread about isqlperl, Takeshi provided info to those of us who want a case insensitive MATCHES and/or LIKE operator. I still would prefer a function like UPPER() for compatibility with other DBMS's, but if Informix would make the EMATCHES operator available in non-Japanese versions, it would go a long way toward addressing our needs. Further thanks to David Coburn (coburn@informix.com) for trying to improve Informix's feature request procedures. Regards, Alan ___________________________ ______________________| R. Alan Popiel |__________________________ \\ Internet: | Martin Marietta, SLS | / \\ alan@den.mmc.com | P.O. Box 179, M/S 3810 | Std disclaimers apply. / )Voice: | Denver, CO 80201-0179 USA | ( / 303-977-9998 |___________________________| (But you knew that!) \\ /________________________) (____________________________\\