functions e.g. UPPER

uunet!mountfield.co.uk!andyw (Andy Wilson) writes: >Are there any plans to include SQL functions, especially UPPER (or LOWER) >in any future or current releases of Informix RDBMS. I doubt it very much that Informix will provide the solution you want, they tend to leave these things up to the developer. As for case insensitive searching try one of the following: - You could have the target columns always be upper. (Our item descriptions are all upper case, this allows indexed queries and makes data entry simpler) - If you must preserve the case that was entered, then create a second column that is always UPPER case and automaticly populated. You can put an index on this second column and perform look-ups against it. - There was a thread on this not to long ago that demonstrated the use of MATCHES in a select statment (but this won't give you an indexed read). >We have clients who have been asking for case insensitive searching for >years! You've been waiting YEARS for someone else to provide solutions for your customers???!!!! >We can do it in Oracle or SQLBase and probably lots of other RDBMSs but >NOT informix No comment. || ======= **** **T* ======= ||John Regep || **** **** ||Store Systems Developement || **** *R** ||Kmart Corporation || =========== ********* =========== ||3100 West Big Beaver || ***A* **** ||Troy, MI 48084 || **** **** ||(810) 643-5078 ||=============== *M** **** ===============||uunet!kmart!jregep