Re: Case Insenstive Matching

Kerry Sainsbury writes: -> ->INFORMIX TAKE NOTE, AGAIN: -> ->Here's yet another request for a case-insensitive search facility in SQL. ->This is a *very* FAQ and it bugs the hell out of me that there is no ->good answer to it - it CAN'T be hard to provide (even if the performance ->of such querys might be appalling) -> ... ->Sheesh. There are some wonky priorities going on somewhere! -> ->Love 'n Kisses, ->Kerry S ->(venting some frustrations into the ether, just in-case somebody listens :-) -> ->PS: If this is scheduled for inclusion sometime, would somebody mind -> dropping me a note and telling me - then I could shut up and leave -> everybody alone. Well, Kerry, I don't think you should shut up. I think that there are enough valid reasons to have such a facility that it warrants inclusion even if the performance is poor. There is a reason it's FAQ, and that's because a LOT of people ask about this capability and I think sometimes the lack of it turns people to other database companies. This is the one feature I can think of that lots of people want and whenever people ask we have to say, "Informix doesn't handle this elegantly, but you can put in a clunky manual solution..." At any rate, maybe this Illustra thing will solve the problem with it's "snap-in" modules for *any kind* of data types (by the way, apparently the term BLOB is about to oudated and they are now the term DataBlades). Maybe all we have to do is create a data type under the Universal Server which makes upper and lower case letters the equivalent of one another - and voila - everything will work. Personally, I am really looking forward to the WorldWide satellite event in February - the product does sound great - maybe this sophisticated technology will even provide an answer to this simple problem for us. Regards, - Cathy -------------------------------------------------------------------------------- Cathy Kipp e-mail: ckipp@vth1.vth.colostate.edu Phone: (970) 491-1294 Colorado State University Veterinary Teaching Hospital Fax: (970) 491-1205